数据故事

该数据来源数据世界并参考世界卫生组织通过世界地图的颜色比较了男性和女性之间这些疾病的患病率及探讨其原因。综上所述,我们发现在大多数国家中,这种疾病在女性中比在男性中更为常见。且发达国家和地区患心理健康疾病的比例也比欠发达的国家和地区高,且患病原因有待探讨。

In [78]:
import pandas as pd
df = pd.read_csv("mental.csv")
In [13]:
df
Out[13]:
Country Year males females
0 Afghanistan 2017 16.674168 16.963023
1 Albania 2017 10.646518 11.043173
2 Algeria 2017 14.063803 15.011597
3 American Samoa 2017 10.687930 11.004269
4 Andean Latin America 2017 11.973561 12.787111
5 Andorra 2017 13.610023 15.861840
6 Angola 2017 12.436696 12.322946
7 Antigua and Barbuda 2017 13.008220 13.392391
8 Argentina 2017 13.698439 17.598748
9 Armenia 2017 10.679067 10.574900
10 Australasia 2017 17.426564 19.354329
11 Australia 2017 17.468624 19.216194
12 Austria 2017 13.064812 15.600716
13 Azerbaijan 2017 10.361989 10.416485
14 Bahamas 2017 13.153293 13.491201
15 Bahrain 2017 13.914962 14.816274
16 Bangladesh 2017 11.611247 13.289032
17 Barbados 2017 13.461973 13.602635
18 Belarus 2017 11.972856 12.081957
19 Belgium 2017 14.329592 15.653381
20 Belize 2017 13.388840 13.472870
21 Benin 2017 11.889258 11.693028
22 Bermuda 2017 13.511998 13.902880
23 Bhutan 2017 11.614106 12.241409
24 Bolivia 2017 12.167645 13.311968
25 Bosnia and Herzegovina 2017 10.809952 11.091413
26 Botswana 2017 12.967178 12.127932
27 Brazil 2017 13.092926 15.792622
28 Brunei 2017 11.163510 11.743905
29 Bulgaria 2017 11.055337 11.374022
... ... ... ... ...
201 Taiwan 2017 11.624662 11.338834
202 Tajikistan 2017 10.649450 10.659094
203 Tanzania 2017 11.855598 12.857774
204 Thailand 2017 11.918767 11.578325
205 Timor 2017 11.094804 12.164470
206 Togo 2017 11.846319 11.644117
207 Tonga 2017 10.756314 11.120704
208 Trinidad and Tobago 2017 13.899191 14.133760
209 Tropical Latin America 2017 13.087586 15.780627
210 Tunisia 2017 15.052460 15.465274
211 Turkey 2017 14.196733 14.355624
212 Turkmenistan 2017 10.608665 10.613201
213 Uganda 2017 12.976859 13.790202
214 Ukraine 2017 12.075127 11.993509
215 United Arab Emirates 2017 12.324823 12.977993
216 United Kingdom 2017 14.033962 15.216455
217 United States 2017 16.263874 18.347446
218 United States Virgin Islands 2017 13.632595 13.892177
219 Uruguay 2017 13.775042 17.557468
220 Uzbekistan 2017 10.731370 10.625033
221 Vanuatu 2017 11.085659 11.318353
222 Venezuela 2017 11.181886 11.003374
223 Vietnam 2017 8.988939 10.346828
224 Wales 2017 13.805811 15.248820
225 Western Europe 2017 13.861182 16.669722
226 Western Sub-Saharan Africa 2017 11.801576 11.802223
227 World 2017 12.581199 13.245729
228 Yemen 2017 15.514807 16.296067
229 Zambia 2017 12.047292 12.528861
230 Zimbabwe 2017 12.561063 10.740696

231 rows × 4 columns

In [14]:
df.Country
Out[14]:
0                       Afghanistan
1                           Albania
2                           Algeria
3                    American Samoa
4              Andean Latin America
5                           Andorra
6                            Angola
7               Antigua and Barbuda
8                         Argentina
9                           Armenia
10                      Australasia
11                        Australia
12                          Austria
13                       Azerbaijan
14                          Bahamas
15                          Bahrain
16                       Bangladesh
17                         Barbados
18                          Belarus
19                          Belgium
20                           Belize
21                            Benin
22                          Bermuda
23                           Bhutan
24                          Bolivia
25           Bosnia and Herzegovina
26                         Botswana
27                           Brazil
28                           Brunei
29                         Bulgaria
                   ...             
201                          Taiwan
202                      Tajikistan
203                        Tanzania
204                        Thailand
205                           Timor
206                            Togo
207                           Tonga
208             Trinidad and Tobago
209          Tropical Latin America
210                         Tunisia
211                          Turkey
212                    Turkmenistan
213                          Uganda
214                         Ukraine
215            United Arab Emirates
216                  United Kingdom
217                   United States
218    United States Virgin Islands
219                         Uruguay
220                      Uzbekistan
221                         Vanuatu
222                       Venezuela
223                         Vietnam
224                           Wales
225                  Western Europe
226      Western Sub-Saharan Africa
227                           World
228                           Yemen
229                          Zambia
230                        Zimbabwe
Name: Country, Length: 231, dtype: object
In [15]:
df.females
Out[15]:
0      16.963023
1      11.043173
2      15.011597
3      11.004269
4      12.787111
5      15.861840
6      12.322946
7      13.392391
8      17.598748
9      10.574900
10     19.354329
11     19.216194
12     15.600716
13     10.416485
14     13.491201
15     14.816274
16     13.289032
17     13.602635
18     12.081957
19     15.653381
20     13.472870
21     11.693028
22     13.902880
23     12.241409
24     13.311968
25     11.091413
26     12.127932
27     15.792622
28     11.743905
29     11.374022
         ...    
201    11.338834
202    10.659094
203    12.857774
204    11.578325
205    12.164470
206    11.644117
207    11.120704
208    14.133760
209    15.780627
210    15.465274
211    14.355624
212    10.613201
213    13.790202
214    11.993509
215    12.977993
216    15.216455
217    18.347446
218    13.892177
219    17.557468
220    10.625033
221    11.318353
222    11.003374
223    10.346828
224    15.248820
225    16.669722
226    11.802223
227    13.245729
228    16.296067
229    12.528861
230    10.740696
Name: females, Length: 231, dtype: float64
In [16]:
df.males
Out[16]:
0      16.674168
1      10.646518
2      14.063803
3      10.687930
4      11.973561
5      13.610023
6      12.436696
7      13.008220
8      13.698439
9      10.679067
10     17.426564
11     17.468624
12     13.064812
13     10.361989
14     13.153293
15     13.914962
16     11.611247
17     13.461973
18     11.972856
19     14.329592
20     13.388840
21     11.889258
22     13.511998
23     11.614106
24     12.167645
25     10.809952
26     12.967178
27     13.092926
28     11.163510
29     11.055337
         ...    
201    11.624662
202    10.649450
203    11.855598
204    11.918767
205    11.094804
206    11.846319
207    10.756314
208    13.899191
209    13.087586
210    15.052460
211    14.196733
212    10.608665
213    12.976859
214    12.075127
215    12.324823
216    14.033962
217    16.263874
218    13.632595
219    13.775042
220    10.731370
221    11.085659
222    11.181886
223     8.988939
224    13.805811
225    13.861182
226    11.801576
227    12.581199
228    15.514807
229    12.047292
230    12.561063
Name: males, Length: 231, dtype: float64
In [17]:
各国男性心理健康障碍患病率 = list(zip(list(df.Country),list(df.males)))
print(各国男性心理健康障碍患病率)
[('Afghanistan', 16.67416817), ('Albania', 10.64651811), ('Algeria', 14.06380308), ('American Samoa', 10.68793033), ('Andean Latin America', 11.97356068), ('Andorra', 13.61002276), ('Angola', 12.43669585), ('Antigua and Barbuda', 13.00821952), ('Argentina', 13.69843913), ('Armenia', 10.67906688), ('Australasia', 17.42656401), ('Australia', 17.46862358), ('Austria', 13.06481225), ('Azerbaijan', 10.36198933), ('Bahamas', 13.15329281), ('Bahrain', 13.91496228), ('Bangladesh', 11.61124711), ('Barbados', 13.46197286), ('Belarus', 11.97285592), ('Belgium', 14.32959246), ('Belize', 13.38883967), ('Benin', 11.88925815), ('Bermuda', 13.51199818), ('Bhutan', 11.614105699999998), ('Bolivia', 12.16764512), ('Bosnia and Herzegovina', 10.8099522), ('Botswana', 12.967178), ('Brazil', 13.09292581), ('Brunei', 11.16350955), ('Bulgaria', 11.05533664), ('Burkina Faso', 11.99977992), ('Burundi', 12.52197071), ('Cambodia', 11.00569858), ('Cameroon', 11.86670138), ('Canada', 15.28562543), ('Cape Verde', 12.75501296), ('Caribbean', 13.47520411), ('Central African Republic', 12.85362372), ('Central Asia', 10.8029663), ('Central Europe', 11.02671844), ('Central Europe, Eastern Europe, and Central Asia', 11.31505007), ('Central Latin America', 10.56520024), ('Central Sub-Saharan Africa', 12.56184524), ('Chad', 12.04486783), ('Chile', 13.967695), ('China', 11.35249761), ('Colombia', 10.43344509), ('Comoros', 11.85924207), ('Congo', 12.31508087), ('Costa Rica', 11.00603676), ("Cote d'Ivoire", 11.64569968), ('Croatia', 11.36712535), ('Cuba', 13.97620114), ('Cyprus', 13.09818835), ('Czech Republic', 11.27347261), ('Democratic Republic of Congo', 12.60708532), ('Denmark', 13.28569218), ('Djibouti', 12.24017226), ('Dominica', 13.19952446), ('Dominican Republic', 13.29665253), ('East Asia', 11.36693767), ('Eastern Europe', 11.73492916), ('Eastern Sub-Saharan Africa', 12.27593371), ('Ecuador', 12.38856483), ('Egypt', 14.29446933), ('El Salvador', 10.78907826), ('England', 14.03463551), ('Equatorial Guinea', 12.43594893), ('Eritrea', 12.37119592), ('Estonia', 11.80539473), ('Ethiopia', 12.53710899), ('Fiji', 10.95245987), ('Finland', 14.58086006), ('France', 14.25309767), ('Gabon', 12.506091), ('Gambia', 11.60140376), ('Georgia', 10.76457749), ('Germany', 13.17717679), ('Ghana', 11.73997671), ('Greece', 14.0109792), ('Greenland', 16.66093702), ('Grenada', 13.39275462), ('Guam', 11.36081544), ('Guatemala', 10.87408272), ('Guinea', 11.62885985), ('Guinea-Bissau', 11.65543595), ('Guyana', 14.17509458), ('Haiti', 13.20468727), ('High SDI', 14.08900942), ('High-income', 14.45598174), ('High-income Asia Pacific', 12.05491117), ('High-middle SDI', 12.29541915), ('Honduras', 10.52434945), ('Hungary', 11.197610800000001), ('Iceland', 13.08986919), ('India', 14.45885164), ('Indonesia', 10.15248794), ('Iran', 17.05942369), ('Iraq', 12.53082199), ('Ireland', 14.41110801), ('Israel', 12.31986302), ('Italy', 13.657126199999999), ('Jamaica', 13.12333348), ('Japan', 12.56811524), ('Jordan', 13.9798924), ('Kazakhstan', 11.20393598), ('Kenya', 11.93529175), ('Kiribati', 11.2850625), ('Kuwait', 13.65292554), ('Kyrgyzstan', 10.997480099999999), ('Laos', 11.61248718), ('Latin America and Caribbean', 11.91924202), ('Latvia', 11.64982837), ('Lebanon', 15.09501885), ('Lesotho', 14.14159748), ('Liberia', 11.42404899), ('Libya', 14.17841664), ('Lithuania', 12.0622496), ('Low SDI', 13.44856223), ('Low-middle SDI', 13.02148124), ('Luxembourg', 13.40541934), ('Macedonia', 10.80843731), ('Madagascar', 12.19106951), ('Malawi', 11.922353999999999), ('Malaysia', 11.45581441), ('Maldives', 10.65300923), ('Mali', 11.31907313), ('Malta', 13.25747182), ('Marshall Islands', 11.03854769), ('Mauritania', 11.62124395), ('Mauritius', 10.82834539), ('Mexico', 10.39246595), ('Micronesia (country)', 11.08075622), ('Middle SDI', 11.61658385), ('Moldova', 11.52270092), ('Mongolia', 11.25406267), ('Montenegro', 10.99517127), ('Morocco', 15.47840828), ('Mozambique', 12.32834321), ('Myanmar', 10.17073899), ('Namibia', 12.73008843), ('Nepal', 12.52838711), ('Netherlands', 14.63224271), ('New Zealand', 17.18089865), ('Nicaragua', 10.88790481), ('Niger', 12.09100472), ('Nigeria', 11.83557218), ('North Africa and Middle East', 14.7801783), ('North America', 16.16828833), ('North Korea', 11.91595804), ('Northern Ireland', 15.97895436), ('Northern Mariana Islands', 11.068200099999999), ('Norway', 14.80513401), ('Oceania', 11.13128848), ('Oman', 13.46183451), ('Pakistan', 11.52209368), ('Palestine', 15.70642814), ('Panama', 10.70246104), ('Papua New Guinea', 11.15925308), ('Paraguay', 12.95005176), ('Peru', 11.71555393), ('Philippines', 10.39104478), ('Poland', 11.06641284), ('Portugal', 13.91262674), ('Puerto Rico', 13.61382087), ('Qatar', 13.59611741), ('Romania', 10.77483797), ('Russia', 11.61144037), ('Rwanda', 12.04162058), ('Saint Lucia', 13.48582736), ('Saint Vincent and the Grenadines', 13.474190599999998), ('Samoa', 10.85143129), ('Sao Tome and Principe', 11.41433574), ('Saudi Arabia', 13.25645543), ('Scotland', 13.44656424), ('Senegal', 11.69102167), ('Serbia', 11.01673013), ('Seychelles', 10.52810266), ('Sierra Leone', 11.68906926), ('Singapore', 12.0350557), ('Slovakia', 10.89585216), ('Slovenia', 11.33071529), ('Solomon Islands', 11.229545199999999), ('Somalia', 12.5931244), ('South Africa', 12.75893546), ('South Asia', 13.83438991), ('South Korea', 11.06356522), ('South Sudan', 11.85204781), ('Southeast Asia', 10.33147405), ('Southeast Asia, East Asia, and Oceania', 11.00054655), ('Southern Latin America', 13.77690148), ('Southern Sub-Saharan Africa', 12.76207642), ('Spain', 14.45882611), ('Sri Lanka', 11.15209358), ('Sub-Saharan Africa', 12.14966965), ('Sudan', 15.92035535), ('Suriname', 14.03425226), ('Swaziland', 13.06597094), ('Sweden', 14.04922185), ('Switzerland', 13.5581555), ('Syria', 14.45703852), ('Taiwan', 11.62466188), ('Tajikistan', 10.64944954), ('Tanzania', 11.85559758), ('Thailand', 11.91876723), ('Timor', 11.09480421), ('Togo', 11.84631867), ('Tonga', 10.75631418), ('Trinidad and Tobago', 13.89919098), ('Tropical Latin America', 13.087585800000001), ('Tunisia', 15.05246048), ('Turkey', 14.19673292), ('Turkmenistan', 10.60866465), ('Uganda', 12.97685878), ('Ukraine', 12.07512714), ('United Arab Emirates', 12.32482273), ('United Kingdom', 14.033961699999999), ('United States', 16.26387429), ('United States Virgin Islands', 13.63259525), ('Uruguay', 13.77504167), ('Uzbekistan', 10.73137001), ('Vanuatu', 11.08565901), ('Venezuela', 11.18188559), ('Vietnam', 8.988939185), ('Wales', 13.80581111), ('Western Europe', 13.86118205), ('Western Sub-Saharan Africa', 11.80157631), ('World', 12.58119894), ('Yemen', 15.51480665), ('Zambia', 12.04729227), ('Zimbabwe', 12.56106349)]
In [26]:
a=list(df.Country.values)
a
Out[26]:
['Afghanistan',
 'Albania',
 'Algeria',
 'American Samoa',
 'Andean Latin America',
 'Andorra',
 'Angola',
 'Antigua and Barbuda',
 'Argentina',
 'Armenia',
 'Australasia',
 'Australia',
 'Austria',
 'Azerbaijan',
 'Bahamas',
 'Bahrain',
 'Bangladesh',
 'Barbados',
 'Belarus',
 'Belgium',
 'Belize',
 'Benin',
 'Bermuda',
 'Bhutan',
 'Bolivia',
 'Bosnia and Herzegovina',
 'Botswana',
 'Brazil',
 'Brunei',
 'Bulgaria',
 'Burkina Faso',
 'Burundi',
 'Cambodia',
 'Cameroon',
 'Canada',
 'Cape Verde',
 'Caribbean',
 'Central African Republic',
 'Central Asia',
 'Central Europe',
 'Central Europe, Eastern Europe, and Central Asia',
 'Central Latin America',
 'Central Sub-Saharan Africa',
 'Chad',
 'Chile',
 'China',
 'Colombia',
 'Comoros',
 'Congo',
 'Costa Rica',
 "Cote d'Ivoire",
 'Croatia',
 'Cuba',
 'Cyprus',
 'Czech Republic',
 'Democratic Republic of Congo',
 'Denmark',
 'Djibouti',
 'Dominica',
 'Dominican Republic',
 'East Asia',
 'Eastern Europe',
 'Eastern Sub-Saharan Africa',
 'Ecuador',
 'Egypt',
 'El Salvador',
 'England',
 'Equatorial Guinea',
 'Eritrea',
 'Estonia',
 'Ethiopia',
 'Fiji',
 'Finland',
 'France',
 'Gabon',
 'Gambia',
 'Georgia',
 'Germany',
 'Ghana',
 'Greece',
 'Greenland',
 'Grenada',
 'Guam',
 'Guatemala',
 'Guinea',
 'Guinea-Bissau',
 'Guyana',
 'Haiti',
 'High SDI',
 'High-income',
 'High-income Asia Pacific',
 'High-middle SDI',
 'Honduras',
 'Hungary',
 'Iceland',
 'India',
 'Indonesia',
 'Iran',
 'Iraq',
 'Ireland',
 'Israel',
 'Italy',
 'Jamaica',
 'Japan',
 'Jordan',
 'Kazakhstan',
 'Kenya',
 'Kiribati',
 'Kuwait',
 'Kyrgyzstan',
 'Laos',
 'Latin America and Caribbean',
 'Latvia',
 'Lebanon',
 'Lesotho',
 'Liberia',
 'Libya',
 'Lithuania',
 'Low SDI',
 'Low-middle SDI',
 'Luxembourg',
 'Macedonia',
 'Madagascar',
 'Malawi',
 'Malaysia',
 'Maldives',
 'Mali',
 'Malta',
 'Marshall Islands',
 'Mauritania',
 'Mauritius',
 'Mexico',
 'Micronesia (country)',
 'Middle SDI',
 'Moldova',
 'Mongolia',
 'Montenegro',
 'Morocco',
 'Mozambique',
 'Myanmar',
 'Namibia',
 'Nepal',
 'Netherlands',
 'New Zealand',
 'Nicaragua',
 'Niger',
 'Nigeria',
 'North Africa and Middle East',
 'North America',
 'North Korea',
 'Northern Ireland',
 'Northern Mariana Islands',
 'Norway',
 'Oceania',
 'Oman',
 'Pakistan',
 'Palestine',
 'Panama',
 'Papua New Guinea',
 'Paraguay',
 'Peru',
 'Philippines',
 'Poland',
 'Portugal',
 'Puerto Rico',
 'Qatar',
 'Romania',
 'Russia',
 'Rwanda',
 'Saint Lucia',
 'Saint Vincent and the Grenadines',
 'Samoa',
 'Sao Tome and Principe',
 'Saudi Arabia',
 'Scotland',
 'Senegal',
 'Serbia',
 'Seychelles',
 'Sierra Leone',
 'Singapore',
 'Slovakia',
 'Slovenia',
 'Solomon Islands',
 'Somalia',
 'South Africa',
 'South Asia',
 'South Korea',
 'South Sudan',
 'Southeast Asia',
 'Southeast Asia, East Asia, and Oceania',
 'Southern Latin America',
 'Southern Sub-Saharan Africa',
 'Spain',
 'Sri Lanka',
 'Sub-Saharan Africa',
 'Sudan',
 'Suriname',
 'Swaziland',
 'Sweden',
 'Switzerland',
 'Syria',
 'Taiwan',
 'Tajikistan',
 'Tanzania',
 'Thailand',
 'Timor',
 'Togo',
 'Tonga',
 'Trinidad and Tobago',
 'Tropical Latin America',
 'Tunisia',
 'Turkey',
 'Turkmenistan',
 'Uganda',
 'Ukraine',
 'United Arab Emirates',
 'United Kingdom',
 'United States',
 'United States Virgin Islands',
 'Uruguay',
 'Uzbekistan',
 'Vanuatu',
 'Venezuela',
 'Vietnam',
 'Wales',
 'Western Europe',
 'Western Sub-Saharan Africa',
 'World',
 'Yemen',
 'Zambia',
 'Zimbabwe']
In [27]:
d=list(df.males.values)
d
Out[27]:
[16.67416817,
 10.64651811,
 14.06380308,
 10.68793033,
 11.97356068,
 13.61002276,
 12.43669585,
 13.00821952,
 13.69843913,
 10.67906688,
 17.42656401,
 17.46862358,
 13.06481225,
 10.36198933,
 13.15329281,
 13.91496228,
 11.61124711,
 13.46197286,
 11.97285592,
 14.32959246,
 13.38883967,
 11.88925815,
 13.51199818,
 11.614105699999998,
 12.16764512,
 10.8099522,
 12.967178,
 13.09292581,
 11.16350955,
 11.05533664,
 11.99977992,
 12.52197071,
 11.00569858,
 11.86670138,
 15.28562543,
 12.75501296,
 13.47520411,
 12.85362372,
 10.8029663,
 11.02671844,
 11.31505007,
 10.56520024,
 12.56184524,
 12.04486783,
 13.967695,
 11.35249761,
 10.43344509,
 11.85924207,
 12.31508087,
 11.00603676,
 11.64569968,
 11.36712535,
 13.97620114,
 13.09818835,
 11.27347261,
 12.60708532,
 13.28569218,
 12.24017226,
 13.19952446,
 13.29665253,
 11.36693767,
 11.73492916,
 12.27593371,
 12.38856483,
 14.29446933,
 10.78907826,
 14.03463551,
 12.43594893,
 12.37119592,
 11.80539473,
 12.53710899,
 10.95245987,
 14.58086006,
 14.25309767,
 12.506091,
 11.60140376,
 10.76457749,
 13.17717679,
 11.73997671,
 14.0109792,
 16.66093702,
 13.39275462,
 11.36081544,
 10.87408272,
 11.62885985,
 11.65543595,
 14.17509458,
 13.20468727,
 14.08900942,
 14.45598174,
 12.05491117,
 12.29541915,
 10.52434945,
 11.197610800000001,
 13.08986919,
 14.45885164,
 10.15248794,
 17.05942369,
 12.53082199,
 14.41110801,
 12.31986302,
 13.657126199999999,
 13.12333348,
 12.56811524,
 13.9798924,
 11.20393598,
 11.93529175,
 11.2850625,
 13.65292554,
 10.997480099999999,
 11.61248718,
 11.91924202,
 11.64982837,
 15.09501885,
 14.14159748,
 11.42404899,
 14.17841664,
 12.0622496,
 13.44856223,
 13.02148124,
 13.40541934,
 10.80843731,
 12.19106951,
 11.922353999999999,
 11.45581441,
 10.65300923,
 11.31907313,
 13.25747182,
 11.03854769,
 11.62124395,
 10.82834539,
 10.39246595,
 11.08075622,
 11.61658385,
 11.52270092,
 11.25406267,
 10.99517127,
 15.47840828,
 12.32834321,
 10.17073899,
 12.73008843,
 12.52838711,
 14.63224271,
 17.18089865,
 10.88790481,
 12.09100472,
 11.83557218,
 14.7801783,
 16.16828833,
 11.91595804,
 15.97895436,
 11.068200099999999,
 14.80513401,
 11.13128848,
 13.46183451,
 11.52209368,
 15.70642814,
 10.70246104,
 11.15925308,
 12.95005176,
 11.71555393,
 10.39104478,
 11.06641284,
 13.91262674,
 13.61382087,
 13.59611741,
 10.77483797,
 11.61144037,
 12.04162058,
 13.48582736,
 13.474190599999998,
 10.85143129,
 11.41433574,
 13.25645543,
 13.44656424,
 11.69102167,
 11.01673013,
 10.52810266,
 11.68906926,
 12.0350557,
 10.89585216,
 11.33071529,
 11.229545199999999,
 12.5931244,
 12.75893546,
 13.83438991,
 11.06356522,
 11.85204781,
 10.33147405,
 11.00054655,
 13.77690148,
 12.76207642,
 14.45882611,
 11.15209358,
 12.14966965,
 15.92035535,
 14.03425226,
 13.06597094,
 14.04922185,
 13.5581555,
 14.45703852,
 11.62466188,
 10.64944954,
 11.85559758,
 11.91876723,
 11.09480421,
 11.84631867,
 10.75631418,
 13.89919098,
 13.087585800000001,
 15.05246048,
 14.19673292,
 10.60866465,
 12.97685878,
 12.07512714,
 12.32482273,
 14.033961699999999,
 16.26387429,
 13.63259525,
 13.77504167,
 10.73137001,
 11.08565901,
 11.18188559,
 8.988939185,
 13.80581111,
 13.86118205,
 11.80157631,
 12.58119894,
 15.51480665,
 12.04729227,
 12.56106349]
In [30]:
from pyecharts.faker import Faker
from pyecharts import options as opts
from pyecharts.charts import Scatter

def scatter_visualmap_color() -> Scatter:
    c = (
        Scatter()
        .add_xaxis(a)
        .add_yaxis("各国男性患病率",d)
        .set_global_opts(
            title_opts=opts.TitleOpts(title="各国男性患病率"),
            visualmap_opts=opts.VisualMapOpts(min_=10,max_=20),
        )
    )
    return c
In [31]:
男性患病率= scatter_visualmap_color()
男性患病率.render_notebook()
Out[31]:
In [32]:
b=list(df.females.values)
b
Out[32]:
[16.96302255,
 11.04317255,
 15.01159706,
 11.00426893,
 12.78711135,
 15.86184049,
 12.32294585,
 13.39239094,
 17.59874775,
 10.57489953,
 19.35432947,
 19.21619405,
 15.60071603,
 10.41648516,
 13.49120068,
 14.81627383,
 13.28903163,
 13.6026348,
 12.08195744,
 15.65338106,
 13.47286976,
 11.693028199999999,
 13.90287959,
 12.24140941,
 13.31196751,
 11.09141289,
 12.12793237,
 15.79262155,
 11.74390488,
 11.37402183,
 11.69866487,
 13.31775657,
 11.86483359,
 11.75166617,
 15.67775188,
 11.94527944,
 13.83525884,
 12.52543399,
 10.74032131,
 11.07793467,
 11.35330022,
 10.87214112,
 12.334849499999999,
 12.13279508,
 18.03206451,
 11.349312699999999,
 9.632960357,
 12.69160245,
 12.24803579,
 11.063826400000002,
 11.36639947,
 11.47753656,
 14.17651035,
 15.31440481,
 11.35739402,
 12.338106100000001,
 15.22011944,
 12.93323532,
 13.36071525,
 13.77695698,
 11.35417594,
 11.77542009,
 13.03665488,
 13.17278014,
 14.85395534,
 11.16447313,
 15.11067396,
 12.39682448,
 13.15261887,
 12.09143264,
 13.13708633,
 11.26542022,
 15.17243141,
 18.31508867,
 12.11815789,
 12.89069875,
 10.62417976,
 17.10398727,
 11.26053647,
 16.94804923,
 18.84740954,
 13.39492198,
 11.38931274,
 11.38034381,
 11.66951167,
 11.74603891,
 14.81224657,
 13.66708124,
 15.76582463,
 16.58878473,
 12.26919107,
 12.92406777,
 10.84039681,
 11.49333065,
 15.32941138,
 14.57455363,
 11.0848362,
 18.37477299,
 14.88806445,
 16.71311162,
 13.06232688,
 16.03737831,
 13.37008289,
 12.12948742,
 14.80317577,
 11.12340044,
 12.65522997,
 11.34281384,
 14.84669463,
 10.90026083,
 12.38845661,
 13.20807069,
 11.46447251,
 16.69713438,
 13.88127814,
 12.71138902,
 15.01543172,
 12.15796108,
 13.71076578,
 13.51480553,
 15.83891198,
 11.14472764,
 12.955444199999999,
 12.62239116,
 12.86586099,
 11.6660741,
 11.13135319,
 15.44068507,
 11.26795078,
 11.02407465,
 11.77589263,
 11.27734572,
 11.27620695,
 12.05362494,
 11.47204216,
 11.10974161,
 11.36457134,
 16.83955197,
 13.03402798,
 10.75678611,
 11.47981766,
 13.00299634,
 17.39198137,
 20.07796042,
 11.00770166,
 11.98280649,
 12.03532903,
 15.76453694,
 18.0854826,
 11.63719877,
 18.45449437,
 11.00313247,
 17.44120257,
 11.42883974,
 14.48148729,
 12.428950500000001,
 16.09246773,
 10.84318046,
 11.46752376,
 15.41172376,
 12.42968215,
 11.21610424,
 10.82358254,
 16.54852173,
 13.50608769,
 14.70538057,
 10.80038069,
 11.68737421,
 13.206261600000001,
 13.51260182,
 13.38006202,
 11.08998763,
 11.2637118,
 14.32870148,
 15.09166848,
 11.24629095,
 11.30709206,
 11.073687300000001,
 11.79165668,
 12.81709577,
 11.1766752,
 11.73401618,
 11.50176167,
 13.43980578,
 12.69554577,
 14.14478189,
 12.55000474,
 12.86651345,
 11.16085472,
 11.3252282,
 17.71580083,
 12.31743926,
 17.80454817,
 11.74478956,
 12.3589356,
 16.21379206,
 14.68237175,
 12.000217999999998,
 17.05990517,
 16.11898788,
 15.1725894,
 11.3388338,
 10.65909441,
 12.85777367,
 11.57832474,
 12.16446983,
 11.64411736,
 11.12070429,
 14.13376015,
 15.78062659,
 15.46527405,
 14.35562438,
 10.6132007,
 13.79020212,
 11.99350866,
 12.97799316,
 15.21645503,
 18.34744604,
 13.89217659,
 17.55746782,
 10.62503286,
 11.31835322,
 11.00337382,
 10.34682823,
 15.24882039,
 16.66972185,
 11.80222319,
 13.24572917,
 16.29606734,
 12.52886108,
 10.74069569]
In [35]:
def scatter_visualmap_color() -> Scatter:
    c = (
        Scatter()
        .add_xaxis(a)
        .add_yaxis("各国女性患病率",b)
        .set_global_opts(
            title_opts=opts.TitleOpts(title="各国女性患病率"),
            visualmap_opts=opts.VisualMapOpts(min_=10,max_=20),
        )
    )
    return c
In [36]:
女性患病率= scatter_visualmap_color()
女性患病率.render_notebook()
Out[36]:

由男女性心理健康患病率的散点图对比分析可知,男性的患病率集中在10%-15%之间,最高的比例也未超过18%;而女性的患病率多集中在11%-17%之间,且最高的患病比例已超过20%,可见这种疾病在女性中比在男性中更为常见。这与女性在社会中所处地位较低,心理和生理健康都比男性要脆弱,社会上应对女性的心理健康提供更多的保障。

2014年-2017年世界男女性心理健康患病率图

In [37]:
df = pd.read_csv('country_males.csv',encoding='gbk')
In [38]:
df
Out[38]:
Country 2014年 2015年 2016年 2017年
0 Afghanistan 16.753068 16.753068 16.710216 16.674168
1 Albania 10.648345 10.648345 10.646706 10.646518
2 Algeria 14.040733 14.040733 14.052904 14.063803
3 American Samoa 10.692175 10.692175 10.690777 10.687930
4 Andean Latin America 11.960583 11.960583 11.966371 11.973561
5 Andorra 13.604457 13.604457 13.606560 13.610023
6 Angola 12.432163 12.432163 12.426484 12.436696
7 Antigua and Barbuda 12.985714 12.985714 12.997266 13.008220
8 Argentina 13.693613 13.693613 13.694336 13.698439
9 Armenia 10.668466 10.668466 10.673325 10.679067
10 Australasia 17.482444 17.482444 17.455354 17.426564
11 Australia 17.541716 17.541716 17.506214 17.468624
12 Austria 13.056921 13.056921 13.061996 13.064812
13 Azerbaijan 10.346065 10.346065 10.352749 10.361989
14 Bahamas 13.139873 13.139873 13.146737 13.153293
15 Bahrain 13.935663 13.935663 13.926110 13.914962
16 Bangladesh 11.683577 11.683577 11.647271 11.611247
17 Barbados 13.450219 13.450219 13.455483 13.461973
18 Belarus 11.990550 11.990550 11.980922 11.972856
19 Belgium 14.316352 14.316352 14.320781 14.329592
20 Belize 13.380601 13.380601 13.384853 13.388840
21 Benin 11.894483 11.894483 11.890957 11.889258
22 Bermuda 13.511195 13.511195 13.513414 13.511998
23 Bhutan 11.611875 11.611875 11.612839 11.614106
24 Bolivia 12.151095 12.151095 12.159193 12.167645
25 Bosnia and Herzegovina 10.814691 10.814691 10.807901 10.809952
26 Botswana 12.962635 12.962635 12.960634 12.967178
27 Brazil 13.137667 13.137667 13.112796 13.092926
28 Brunei 11.146618 11.146618 11.156479 11.163510
29 Bulgaria 11.049463 11.049463 11.050733 11.055337
... ... ... ... ... ...
201 Taiwan 11.640860 11.640860 11.633695 11.624662
202 Tajikistan 10.677559 10.677559 10.664176 10.649450
203 Tanzania 11.830207 11.830207 11.840556 11.855598
204 Thailand 11.985698 11.985698 11.950009 11.918767
205 Timor 11.166420 11.166420 11.129563 11.094804
206 Togo 11.843465 11.843465 11.845105 11.846319
207 Tonga 10.763040 10.763040 10.757886 10.756314
208 Trinidad and Tobago 13.899670 13.899670 13.896499 13.899191
209 Tropical Latin America 13.131173 13.131173 13.106959 13.087586
210 Tunisia 15.063216 15.063216 15.057527 15.052460
211 Turkey 14.232132 14.232132 14.216167 14.196733
212 Turkmenistan 10.598564 10.598564 10.604102 10.608665
213 Uganda 13.008787 13.008787 12.994770 12.976859
214 Ukraine 12.079771 12.079771 12.080820 12.075127
215 United Arab Emirates 12.306707 12.306707 12.319466 12.324823
216 United Kingdom 14.022247 14.022247 14.027517 14.033962
217 United States 16.278150 16.278150 16.270533 16.263874
218 United States Virgin Islands 13.632367 13.632367 13.632504 13.632595
219 Uruguay 13.759703 13.759703 13.762565 13.775042
220 Uzbekistan 10.752260 10.752260 10.744390 10.731370
221 Vanuatu 11.103429 11.103429 11.095058 11.085659
222 Venezuela 11.186214 11.186214 11.184497 11.181886
223 Vietnam 8.966948 8.966948 8.973221 8.988939
224 Wales 13.772225 13.772225 13.784068 13.805811
225 Western Europe 13.871859 13.871859 13.864468 13.861182
226 Western Sub-Saharan Africa 11.843181 11.843181 11.824578 11.801576
227 World 12.595280 12.595280 12.588114 12.581199
228 Yemen 15.410116 15.410116 15.458473 15.514807
229 Zambia 11.994085 11.994085 12.016855 12.047292
230 Zimbabwe 12.529954 12.529954 12.546594 12.561063

231 rows × 5 columns

In [39]:
for i in range(2014,2018):
    print(list(zip(list(df.Country),list(df["{}年".format(i)]))))
[('Afghanistan', 16.75306774), ('Albania', 10.64834484), ('Algeria', 14.04073325), ('American Samoa', 10.69217484), ('Andean Latin America', 11.96058294), ('Andorra', 13.60445701), ('Angola', 12.43216273), ('Antigua and Barbuda', 12.98571441), ('Argentina', 13.693613099999999), ('Armenia', 10.66846575), ('Australasia', 17.48244379), ('Australia', 17.5417157), ('Austria', 13.0569209), ('Azerbaijan', 10.34606519), ('Bahamas', 13.13987283), ('Bahrain', 13.93566286), ('Bangladesh', 11.68357749), ('Barbados', 13.4502185), ('Belarus', 11.99055015), ('Belgium', 14.31635168), ('Belize', 13.38060095), ('Benin', 11.89448323), ('Bermuda', 13.51119534), ('Bhutan', 11.61187518), ('Bolivia', 12.15109511), ('Bosnia and Herzegovina', 10.81469116), ('Botswana', 12.96263546), ('Brazil', 13.1376673), ('Brunei', 11.14661798), ('Bulgaria', 11.04946267), ('Burkina Faso', 11.99926023), ('Burundi', 12.51429148), ('Cambodia', 11.09367967), ('Cameroon', 11.86821639), ('Canada', 15.23991322), ('Cape Verde', 12.76697234), ('Caribbean', 13.47537007), ('Central African Republic', 12.84544228), ('Central Asia', 10.81437141), ('Central Europe', 11.02839755), ('Central Europe, Eastern Europe, and Central Asia', 11.32344874), ('Central Latin America', 10.543919800000001), ('Central Sub-Saharan Africa', 12.58834133), ('Chad', 12.06724311), ('Chile', 13.95745981), ('China', 11.39474934), ('Colombia', 10.40575923), ('Comoros', 11.81482608), ('Congo', 12.29624383), ('Costa Rica', 10.99572287), ("Cote d'Ivoire", 11.59835209), ('Croatia', 11.37125952), ('Cuba', 13.9771386), ('Cyprus', 13.08969953), ('Czech Republic', 11.27719677), ('Democratic Republic of Congo', 12.64870278), ('Denmark', 13.30040468), ('Djibouti', 12.22858991), ('Dominica', 13.18481996), ('Dominican Republic', 13.28666083), ('East Asia', 11.40807681), ('Eastern Europe', 11.73588221), ('Eastern Sub-Saharan Africa', 12.30278909), ('Ecuador', 12.35992247), ('Egypt', 14.25407228), ('El Salvador', 10.78078676), ('England', 14.01874982), ('Equatorial Guinea', 12.4083714), ('Eritrea', 12.38025317), ('Estonia', 11.808701300000001), ('Ethiopia', 12.60042613), ('Fiji', 10.9573569), ('Finland', 14.63350269), ('France', 14.25999645), ('Gabon', 12.5006247), ('Gambia', 11.57262031), ('Georgia', 10.75236178), ('Germany', 13.215347400000002), ('Ghana', 11.70245383), ('Greece', 14.05690627), ('Greenland', 16.69531109), ('Grenada', 13.38709916), ('Guam', 11.38634182), ('Guatemala', 10.88260856), ('Guinea', 11.62570707), ('Guinea-Bissau', 11.65574864), ('Guyana', 14.196930300000002), ('Haiti', 13.21063548), ('High SDI', 14.07771203), ('High-income', 14.44867161), ('High-income Asia Pacific', 12.0110742), ('High-middle SDI', 12.30195484), ('Honduras', 10.511519900000001), ('Hungary', 11.19613924), ('Iceland', 13.07430478), ('India', 14.48041012), ('Indonesia', 10.19548517), ('Iran', 17.10515044), ('Iraq', 12.51640219), ('Ireland', 14.41573785), ('Israel', 12.37333434), ('Italy', 13.64377137), ('Jamaica', 13.10665571), ('Japan', 12.50892752), ('Jordan', 13.96355962), ('Kazakhstan', 11.20716643), ('Kenya', 11.94361848), ('Kiribati', 11.30531562), ('Kuwait', 13.617170499999999), ('Kyrgyzstan', 11.01629241), ('Laos', 11.68110429), ('Latin America and Caribbean', 11.93323463), ('Latvia', 11.63982479), ('Lebanon', 15.11374189), ('Lesotho', 14.14745232), ('Liberia', 11.44645072), ('Libya', 14.04713759), ('Lithuania', 12.05136588), ('Low SDI', 13.500414600000001), ('Low-middle SDI', 13.06063975), ('Luxembourg', 13.40093713), ('Macedonia', 10.80468757), ('Madagascar', 12.2000426), ('Malawi', 11.86167603), ('Malaysia', 11.46853908), ('Maldives', 10.68382982), ('Mali', 11.29643857), ('Malta', 13.23622222), ('Marshall Islands', 11.07409863), ('Mauritania', 11.58699221), ('Mauritius', 10.84595366), ('Mexico', 10.36060883), ('Micronesia (country)', 11.11215038), ('Middle SDI', 11.62930786), ('Moldova', 11.53233558), ('Mongolia', 11.27413316), ('Montenegro', 10.99537376), ('Morocco', 15.60313544), ('Mozambique', 12.33140432), ('Myanmar', 10.24095966), ('Namibia', 12.66672308), ('Nepal', 12.61085829), ('Netherlands', 14.64030937), ('New Zealand', 17.15716344), ('Nicaragua', 10.88840003), ('Niger', 12.08067733), ('Nigeria', 11.93993977), ('North Africa and Middle East', 14.78606624), ('North America', 16.17717485), ('North Korea', 11.91165531), ('Northern Ireland', 16.19748175), ('Northern Mariana Islands', 11.08982971), ('Norway', 14.74915644), ('Oceania', 11.18005491), ('Oman', 13.43155902), ('Pakistan', 11.60495993), ('Palestine', 15.82958053), ('Panama', 10.6803106), ('Papua New Guinea', 11.21753766), ('Paraguay', 12.94106664), ('Peru', 11.71187624), ('Philippines', 10.42211416), ('Poland', 11.0754087), ('Portugal', 13.982741699999998), ('Puerto Rico', 13.55617167), ('Qatar', 13.60175173), ('Romania', 10.76559147), ('Russia', 11.60781216), ('Rwanda', 12.01191881), ('Saint Lucia', 13.48585676), ('Saint Vincent and the Grenadines', 13.46445628), ('Samoa', 10.87308504), ('Sao Tome and Principe', 11.40172151), ('Saudi Arabia', 13.23259688), ('Scotland', 13.41587871), ('Senegal', 11.66275244), ('Serbia', 11.02036288), ('Seychelles', 10.55688476), ('Sierra Leone', 11.69887541), ('Singapore', 12.03986959), ('Slovakia', 10.89514031), ('Slovenia', 11.34078163), ('Solomon Islands', 11.28115855), ('Somalia', 12.95510515), ('South Africa', 12.71426357), ('South Asia', 13.87509431), ('South Korea', 11.0387813), ('South Sudan', 11.83744532), ('Southeast Asia', 10.37145833), ('Southeast Asia, East Asia, and Oceania', 11.04283763), ('Southern Latin America', 13.77071268), ('Southern Sub-Saharan Africa', 12.72121549), ('Spain', 14.45260241), ('Sri Lanka', 11.20967914), ('Sub-Saharan Africa', 12.17794106), ('Sudan', 15.90137244), ('Suriname', 14.03628633), ('Swaziland', 13.02198962), ('Sweden', 14.06287004), ('Switzerland', 13.54088115), ('Syria', 14.41073809), ('Taiwan', 11.64085994), ('Tajikistan', 10.67755916), ('Tanzania', 11.83020721), ('Thailand', 11.98569818), ('Timor', 11.16641994), ('Togo', 11.84346511), ('Tonga', 10.76304025), ('Trinidad and Tobago', 13.89966963), ('Tropical Latin America', 13.13117307), ('Tunisia', 15.06321639), ('Turkey', 14.23213201), ('Turkmenistan', 10.59856428), ('Uganda', 13.00878703), ('Ukraine', 12.07977145), ('United Arab Emirates', 12.30670712), ('United Kingdom', 14.02224704), ('United States', 16.27814981), ('United States Virgin Islands', 13.63236669), ('Uruguay', 13.75970288), ('Uzbekistan', 10.75225976), ('Vanuatu', 11.10342852), ('Venezuela', 11.186214199999998), ('Vietnam', 8.966947897), ('Wales', 13.77222513), ('Western Europe', 13.87185874), ('Western Sub-Saharan Africa', 11.84318086), ('World', 12.59527957), ('Yemen', 15.410115900000001), ('Zambia', 11.99408469), ('Zimbabwe', 12.52995425)]
[('Afghanistan', 16.75306774), ('Albania', 10.64834484), ('Algeria', 14.04073325), ('American Samoa', 10.69217484), ('Andean Latin America', 11.96058294), ('Andorra', 13.60445701), ('Angola', 12.43216273), ('Antigua and Barbuda', 12.98571441), ('Argentina', 13.693613099999999), ('Armenia', 10.66846575), ('Australasia', 17.48244379), ('Australia', 17.5417157), ('Austria', 13.0569209), ('Azerbaijan', 10.34606519), ('Bahamas', 13.13987283), ('Bahrain', 13.93566286), ('Bangladesh', 11.68357749), ('Barbados', 13.4502185), ('Belarus', 11.99055015), ('Belgium', 14.31635168), ('Belize', 13.38060095), ('Benin', 11.89448323), ('Bermuda', 13.51119534), ('Bhutan', 11.61187518), ('Bolivia', 12.15109511), ('Bosnia and Herzegovina', 10.81469116), ('Botswana', 12.96263546), ('Brazil', 13.1376673), ('Brunei', 11.14661798), ('Bulgaria', 11.04946267), ('Burkina Faso', 11.99926023), ('Burundi', 12.51429148), ('Cambodia', 11.09367967), ('Cameroon', 11.86821639), ('Canada', 15.23991322), ('Cape Verde', 12.76697234), ('Caribbean', 13.47537007), ('Central African Republic', 12.84544228), ('Central Asia', 10.81437141), ('Central Europe', 11.02839755), ('Central Europe, Eastern Europe, and Central Asia', 11.32344874), ('Central Latin America', 10.543919800000001), ('Central Sub-Saharan Africa', 12.58834133), ('Chad', 12.06724311), ('Chile', 13.95745981), ('China', 11.39474934), ('Colombia', 10.40575923), ('Comoros', 11.81482608), ('Congo', 12.29624383), ('Costa Rica', 10.99572287), ("Cote d'Ivoire", 11.59835209), ('Croatia', 11.37125952), ('Cuba', 13.9771386), ('Cyprus', 13.08969953), ('Czech Republic', 11.27719677), ('Democratic Republic of Congo', 12.64870278), ('Denmark', 13.30040468), ('Djibouti', 12.22858991), ('Dominica', 13.18481996), ('Dominican Republic', 13.28666083), ('East Asia', 11.40807681), ('Eastern Europe', 11.73588221), ('Eastern Sub-Saharan Africa', 12.30278909), ('Ecuador', 12.35992247), ('Egypt', 14.25407228), ('El Salvador', 10.78078676), ('England', 14.01874982), ('Equatorial Guinea', 12.4083714), ('Eritrea', 12.38025317), ('Estonia', 11.808701300000001), ('Ethiopia', 12.60042613), ('Fiji', 10.9573569), ('Finland', 14.63350269), ('France', 14.25999645), ('Gabon', 12.5006247), ('Gambia', 11.57262031), ('Georgia', 10.75236178), ('Germany', 13.215347400000002), ('Ghana', 11.70245383), ('Greece', 14.05690627), ('Greenland', 16.69531109), ('Grenada', 13.38709916), ('Guam', 11.38634182), ('Guatemala', 10.88260856), ('Guinea', 11.62570707), ('Guinea-Bissau', 11.65574864), ('Guyana', 14.196930300000002), ('Haiti', 13.21063548), ('High SDI', 14.07771203), ('High-income', 14.44867161), ('High-income Asia Pacific', 12.0110742), ('High-middle SDI', 12.30195484), ('Honduras', 10.511519900000001), ('Hungary', 11.19613924), ('Iceland', 13.07430478), ('India', 14.48041012), ('Indonesia', 10.19548517), ('Iran', 17.10515044), ('Iraq', 12.51640219), ('Ireland', 14.41573785), ('Israel', 12.37333434), ('Italy', 13.64377137), ('Jamaica', 13.10665571), ('Japan', 12.50892752), ('Jordan', 13.96355962), ('Kazakhstan', 11.20716643), ('Kenya', 11.94361848), ('Kiribati', 11.30531562), ('Kuwait', 13.617170499999999), ('Kyrgyzstan', 11.01629241), ('Laos', 11.68110429), ('Latin America and Caribbean', 11.93323463), ('Latvia', 11.63982479), ('Lebanon', 15.11374189), ('Lesotho', 14.14745232), ('Liberia', 11.44645072), ('Libya', 14.04713759), ('Lithuania', 12.05136588), ('Low SDI', 13.500414600000001), ('Low-middle SDI', 13.06063975), ('Luxembourg', 13.40093713), ('Macedonia', 10.80468757), ('Madagascar', 12.2000426), ('Malawi', 11.86167603), ('Malaysia', 11.46853908), ('Maldives', 10.68382982), ('Mali', 11.29643857), ('Malta', 13.23622222), ('Marshall Islands', 11.07409863), ('Mauritania', 11.58699221), ('Mauritius', 10.84595366), ('Mexico', 10.36060883), ('Micronesia (country)', 11.11215038), ('Middle SDI', 11.62930786), ('Moldova', 11.53233558), ('Mongolia', 11.27413316), ('Montenegro', 10.99537376), ('Morocco', 15.60313544), ('Mozambique', 12.33140432), ('Myanmar', 10.24095966), ('Namibia', 12.66672308), ('Nepal', 12.61085829), ('Netherlands', 14.64030937), ('New Zealand', 17.15716344), ('Nicaragua', 10.88840003), ('Niger', 12.08067733), ('Nigeria', 11.93993977), ('North Africa and Middle East', 14.78606624), ('North America', 16.17717485), ('North Korea', 11.91165531), ('Northern Ireland', 16.19748175), ('Northern Mariana Islands', 11.08982971), ('Norway', 14.74915644), ('Oceania', 11.18005491), ('Oman', 13.43155902), ('Pakistan', 11.60495993), ('Palestine', 15.82958053), ('Panama', 10.6803106), ('Papua New Guinea', 11.21753766), ('Paraguay', 12.94106664), ('Peru', 11.71187624), ('Philippines', 10.42211416), ('Poland', 11.0754087), ('Portugal', 13.982741699999998), ('Puerto Rico', 13.55617167), ('Qatar', 13.60175173), ('Romania', 10.76559147), ('Russia', 11.60781216), ('Rwanda', 12.01191881), ('Saint Lucia', 13.48585676), ('Saint Vincent and the Grenadines', 13.46445628), ('Samoa', 10.87308504), ('Sao Tome and Principe', 11.40172151), ('Saudi Arabia', 13.23259688), ('Scotland', 13.41587871), ('Senegal', 11.66275244), ('Serbia', 11.02036288), ('Seychelles', 10.55688476), ('Sierra Leone', 11.69887541), ('Singapore', 12.03986959), ('Slovakia', 10.89514031), ('Slovenia', 11.34078163), ('Solomon Islands', 11.28115855), ('Somalia', 12.95510515), ('South Africa', 12.71426357), ('South Asia', 13.87509431), ('South Korea', 11.0387813), ('South Sudan', 11.83744532), ('Southeast Asia', 10.37145833), ('Southeast Asia, East Asia, and Oceania', 11.04283763), ('Southern Latin America', 13.77071268), ('Southern Sub-Saharan Africa', 12.72121549), ('Spain', 14.45260241), ('Sri Lanka', 11.20967914), ('Sub-Saharan Africa', 12.17794106), ('Sudan', 15.90137244), ('Suriname', 14.03628633), ('Swaziland', 13.02198962), ('Sweden', 14.06287004), ('Switzerland', 13.54088115), ('Syria', 14.41073809), ('Taiwan', 11.64085994), ('Tajikistan', 10.67755916), ('Tanzania', 11.83020721), ('Thailand', 11.98569818), ('Timor', 11.16641994), ('Togo', 11.84346511), ('Tonga', 10.76304025), ('Trinidad and Tobago', 13.89966963), ('Tropical Latin America', 13.13117307), ('Tunisia', 15.06321639), ('Turkey', 14.23213201), ('Turkmenistan', 10.59856428), ('Uganda', 13.00878703), ('Ukraine', 12.07977145), ('United Arab Emirates', 12.30670712), ('United Kingdom', 14.02224704), ('United States', 16.27814981), ('United States Virgin Islands', 13.63236669), ('Uruguay', 13.75970288), ('Uzbekistan', 10.75225976), ('Vanuatu', 11.10342852), ('Venezuela', 11.186214199999998), ('Vietnam', 8.966947897), ('Wales', 13.77222513), ('Western Europe', 13.87185874), ('Western Sub-Saharan Africa', 11.84318086), ('World', 12.59527957), ('Yemen', 15.410115900000001), ('Zambia', 11.99408469), ('Zimbabwe', 12.52995425)]
[('Afghanistan', 16.71021624), ('Albania', 10.64670602), ('Algeria', 14.05290396), ('American Samoa', 10.69077718), ('Andean Latin America', 11.96637114), ('Andorra', 13.60656022), ('Angola', 12.426484), ('Antigua and Barbuda', 12.99726602), ('Argentina', 13.69433625), ('Armenia', 10.67332526), ('Australasia', 17.4553535), ('Australia', 17.50621383), ('Austria', 13.06199632), ('Azerbaijan', 10.35274919), ('Bahamas', 13.14673746), ('Bahrain', 13.92611012), ('Bangladesh', 11.64727115), ('Barbados', 13.45548259), ('Belarus', 11.98092206), ('Belgium', 14.32078129), ('Belize', 13.38485334), ('Benin', 11.89095728), ('Bermuda', 13.51341424), ('Bhutan', 11.61283902), ('Bolivia', 12.15919313), ('Bosnia and Herzegovina', 10.80790057), ('Botswana', 12.96063443), ('Brazil', 13.11279634), ('Brunei', 11.15647852), ('Bulgaria', 11.05073275), ('Burkina Faso', 11.99943482), ('Burundi', 12.51469666), ('Cambodia', 11.04409964), ('Cameroon', 11.87319041), ('Canada', 15.26142538), ('Cape Verde', 12.76174853), ('Caribbean', 13.4751294), ('Central African Republic', 12.84643674), ('Central Asia', 10.80882975), ('Central Europe', 11.02664849), ('Central Europe, Eastern Europe, and Central Asia', 11.31896693), ('Central Latin America', 10.55389565), ('Central Sub-Saharan Africa', 12.5723606), ('Chad', 12.05418303), ('Chile', 13.96068761), ('China', 11.37474847), ('Colombia', 10.41903223), ('Comoros', 11.83292893), ('Congo', 12.30198471), ('Costa Rica', 11.00020369), ("Cote d'Ivoire", 11.62149345), ('Croatia', 11.36731734), ('Cuba', 13.97813514), ('Cyprus', 13.09046045), ('Czech Republic', 11.27498223), ('Democratic Republic of Congo', 12.62671861), ('Denmark', 13.29127827), ('Djibouti', 12.23065554), ('Dominica', 13.19107443), ('Dominican Republic', 13.29205093), ('East Asia', 11.3886198), ('Eastern Europe', 11.73560382), ('Eastern Sub-Saharan Africa', 12.28903043), ('Ecuador', 12.37284264), ('Egypt', 14.27453957), ('El Salvador', 10.78682587), ('England', 14.02636086), ('Equatorial Guinea', 12.42540335), ('Eritrea', 12.37380081), ('Estonia', 11.80482266), ('Ethiopia', 12.56578118), ('Fiji', 10.95333291), ('Finland', 14.60829983), ('France', 14.253009699999998), ('Gabon', 12.50338776), ('Gambia', 11.58616941), ('Georgia', 10.75639893), ('Germany', 13.19906797), ('Ghana', 11.71799447), ('Greece', 14.03455773), ('Greenland', 16.6784536), ('Grenada', 13.38855308), ('Guam', 11.37310929), ('Guatemala', 10.87614755), ('Guinea', 11.62865492), ('Guinea-Bissau', 11.654402099999999), ('Guyana', 14.18631003), ('Haiti', 13.20732512), ('High SDI', 14.08194781), ('High-income', 14.45048431), ('High-income Asia Pacific', 12.03305726), ('High-middle SDI', 12.29957516), ('Honduras', 10.51690791), ('Hungary', 11.19284117), ('Iceland', 13.0821185), ('India', 14.46786251), ('Indonesia', 10.17136812), ('Iran', 17.08698928), ('Iraq', 12.51800342), ('Ireland', 14.41364021), ('Israel', 12.34369849), ('Italy', 13.64870785), ('Jamaica', 13.11299299), ('Japan', 12.53822497), ('Jordan', 13.96909289), ('Kazakhstan', 11.20301466), ('Kenya', 11.93844827), ('Kiribati', 11.29381122), ('Kuwait', 13.63263518), ('Kyrgyzstan', 11.00487381), ('Laos', 11.64439186), ('Latin America and Caribbean', 11.92486084), ('Latvia', 11.63970031), ('Lebanon', 15.10728679), ('Lesotho', 14.14482549), ('Liberia', 11.44114518), ('Libya', 14.10865909), ('Lithuania', 12.05518755), ('Low SDI', 13.47394634), ('Low-middle SDI', 13.04044523), ('Luxembourg', 13.40468465), ('Macedonia', 10.80539856), ('Madagascar', 12.19733348), ('Malawi', 11.89109074), ('Malaysia', 11.46069666), ('Maldives', 10.66606182), ('Mali', 11.30476882), ('Malta', 13.24287478), ('Marshall Islands', 11.05588738), ('Mauritania', 11.60322931), ('Mauritius', 10.83460462), ('Mexico', 10.37544005), ('Micronesia (country)', 11.09650301), ('Middle SDI', 11.62240304), ('Moldova', 11.52907253), ('Mongolia', 11.264455300000002), ('Montenegro', 10.99210432), ('Morocco', 15.54262384), ('Mozambique', 12.327074099999999), ('Myanmar', 10.20179744), ('Namibia', 12.69502935), ('Nepal', 12.56854261), ('Netherlands', 14.63815524), ('New Zealand', 17.16874807), ('Nicaragua', 10.88917641), ('Niger', 12.08666632), ('Nigeria', 11.89279719), ('North Africa and Middle East', 14.78218023), ('North America', 16.17217286), ('North Korea', 11.91335508), ('Northern Ireland', 16.09485002), ('Northern Mariana Islands', 11.07685271), ('Norway', 14.77511317), ('Oceania', 11.15561182), ('Oman', 13.44591763), ('Pakistan', 11.56252438), ('Palestine', 15.76949414), ('Panama', 10.68732671), ('Papua New Guinea', 11.18836611), ('Paraguay', 12.945650800000001), ('Peru', 11.71297561), ('Philippines', 10.40696226), ('Poland', 11.07101602), ('Portugal', 13.95214945), ('Puerto Rico', 13.58109413), ('Qatar', 13.59618518), ('Romania', 10.76749745), ('Russia', 11.60878055), ('Rwanda', 12.0237121), ('Saint Lucia', 13.48502511), ('Saint Vincent and the Grenadines', 13.46794519), ('Samoa', 10.86303053), ('Sao Tome and Principe', 11.4050218), ('Saudi Arabia', 13.24311077), ('Scotland', 13.42819494), ('Senegal', 11.67646742), ('Serbia', 11.02051544), ('Seychelles', 10.54183826), ('Sierra Leone', 11.69370602), ('Singapore', 12.03461238), ('Slovakia', 10.89688119), ('Slovenia', 11.33363922), ('Solomon Islands', 11.25576984), ('Somalia', 12.79575088), ('South Africa', 12.73524812), ('South Asia', 13.8536071), ('South Korea', 11.05206052), ('South Sudan', 11.84724794), ('Southeast Asia', 10.34918313), ('Southeast Asia, East Asia, and Oceania', 11.02143201), ('Southern Latin America', 13.77201993), ('Southern Sub-Saharan Africa', 12.74048576), ('Spain', 14.4570187), ('Sri Lanka', 11.18459559), ('Sub-Saharan Africa', 12.16416585), ('Sudan', 15.90842158), ('Suriname', 14.03454875), ('Swaziland', 13.04207913), ('Sweden', 14.05489787), ('Switzerland', 13.54252273), ('Syria', 14.43621294), ('Taiwan', 11.63369479), ('Tajikistan', 10.6641759), ('Tanzania', 11.84055573), ('Thailand', 11.95000942), ('Timor', 11.12956259), ('Togo', 11.84510497), ('Tonga', 10.75788618), ('Trinidad and Tobago', 13.89649934), ('Tropical Latin America', 13.10695921), ('Tunisia', 15.05752742), ('Turkey', 14.21616718), ('Turkmenistan', 10.60410194), ('Uganda', 12.99476976), ('Ukraine', 12.0808196), ('United Arab Emirates', 12.31946597), ('United Kingdom', 14.02751681), ('United States', 16.27053323), ('United States Virgin Islands', 13.63250416), ('Uruguay', 13.76256507), ('Uzbekistan', 10.74439015), ('Vanuatu', 11.09505837), ('Venezuela', 11.18449738), ('Vietnam', 8.973220702999999), ('Wales', 13.7840684), ('Western Europe', 13.86446825), ('Western Sub-Saharan Africa', 11.82457751), ('World', 12.58811415), ('Yemen', 15.45847286), ('Zambia', 12.01685488), ('Zimbabwe', 12.54659446)]
[('Afghanistan', 16.67416817), ('Albania', 10.64651811), ('Algeria', 14.06380308), ('American Samoa', 10.68793033), ('Andean Latin America', 11.97356068), ('Andorra', 13.61002276), ('Angola', 12.43669585), ('Antigua and Barbuda', 13.00821952), ('Argentina', 13.69843913), ('Armenia', 10.67906688), ('Australasia', 17.42656401), ('Australia', 17.46862358), ('Austria', 13.06481225), ('Azerbaijan', 10.36198933), ('Bahamas', 13.15329281), ('Bahrain', 13.91496228), ('Bangladesh', 11.61124711), ('Barbados', 13.46197286), ('Belarus', 11.97285592), ('Belgium', 14.32959246), ('Belize', 13.38883967), ('Benin', 11.88925815), ('Bermuda', 13.51199818), ('Bhutan', 11.614105699999998), ('Bolivia', 12.16764512), ('Bosnia and Herzegovina', 10.8099522), ('Botswana', 12.967178), ('Brazil', 13.09292581), ('Brunei', 11.16350955), ('Bulgaria', 11.05533664), ('Burkina Faso', 11.99977992), ('Burundi', 12.52197071), ('Cambodia', 11.00569858), ('Cameroon', 11.86670138), ('Canada', 15.28562543), ('Cape Verde', 12.75501296), ('Caribbean', 13.47520411), ('Central African Republic', 12.85362372), ('Central Asia', 10.8029663), ('Central Europe', 11.02671844), ('Central Europe, Eastern Europe, and Central Asia', 11.31505007), ('Central Latin America', 10.56520024), ('Central Sub-Saharan Africa', 12.56184524), ('Chad', 12.04486783), ('Chile', 13.967695), ('China', 11.35249761), ('Colombia', 10.43344509), ('Comoros', 11.85924207), ('Congo', 12.31508087), ('Costa Rica', 11.00603676), ("Cote d'Ivoire", 11.64569968), ('Croatia', 11.36712535), ('Cuba', 13.97620114), ('Cyprus', 13.09818835), ('Czech Republic', 11.27347261), ('Democratic Republic of Congo', 12.60708532), ('Denmark', 13.28569218), ('Djibouti', 12.24017226), ('Dominica', 13.19952446), ('Dominican Republic', 13.29665253), ('East Asia', 11.36693767), ('Eastern Europe', 11.73492916), ('Eastern Sub-Saharan Africa', 12.27593371), ('Ecuador', 12.38856483), ('Egypt', 14.29446933), ('El Salvador', 10.78907826), ('England', 14.03463551), ('Equatorial Guinea', 12.43594893), ('Eritrea', 12.37119592), ('Estonia', 11.80539473), ('Ethiopia', 12.53710899), ('Fiji', 10.95245987), ('Finland', 14.58086006), ('France', 14.25309767), ('Gabon', 12.506091), ('Gambia', 11.60140376), ('Georgia', 10.76457749), ('Germany', 13.17717679), ('Ghana', 11.73997671), ('Greece', 14.0109792), ('Greenland', 16.66093702), ('Grenada', 13.39275462), ('Guam', 11.36081544), ('Guatemala', 10.87408272), ('Guinea', 11.62885985), ('Guinea-Bissau', 11.65543595), ('Guyana', 14.17509458), ('Haiti', 13.20468727), ('High SDI', 14.08900942), ('High-income', 14.45598174), ('High-income Asia Pacific', 12.05491117), ('High-middle SDI', 12.29541915), ('Honduras', 10.52434945), ('Hungary', 11.197610800000001), ('Iceland', 13.08986919), ('India', 14.45885164), ('Indonesia', 10.15248794), ('Iran', 17.05942369), ('Iraq', 12.53082199), ('Ireland', 14.41110801), ('Israel', 12.31986302), ('Italy', 13.657126199999999), ('Jamaica', 13.12333348), ('Japan', 12.56811524), ('Jordan', 13.9798924), ('Kazakhstan', 11.20393598), ('Kenya', 11.93529175), ('Kiribati', 11.2850625), ('Kuwait', 13.65292554), ('Kyrgyzstan', 10.997480099999999), ('Laos', 11.61248718), ('Latin America and Caribbean', 11.91924202), ('Latvia', 11.64982837), ('Lebanon', 15.09501885), ('Lesotho', 14.14159748), ('Liberia', 11.42404899), ('Libya', 14.17841664), ('Lithuania', 12.0622496), ('Low SDI', 13.44856223), ('Low-middle SDI', 13.02148124), ('Luxembourg', 13.40541934), ('Macedonia', 10.80843731), ('Madagascar', 12.19106951), ('Malawi', 11.922353999999999), ('Malaysia', 11.45581441), ('Maldives', 10.65300923), ('Mali', 11.31907313), ('Malta', 13.25747182), ('Marshall Islands', 11.03854769), ('Mauritania', 11.62124395), ('Mauritius', 10.82834539), ('Mexico', 10.39246595), ('Micronesia (country)', 11.08075622), ('Middle SDI', 11.61658385), ('Moldova', 11.52270092), ('Mongolia', 11.25406267), ('Montenegro', 10.99517127), ('Morocco', 15.47840828), ('Mozambique', 12.32834321), ('Myanmar', 10.17073899), ('Namibia', 12.73008843), ('Nepal', 12.52838711), ('Netherlands', 14.63224271), ('New Zealand', 17.18089865), ('Nicaragua', 10.88790481), ('Niger', 12.09100472), ('Nigeria', 11.83557218), ('North Africa and Middle East', 14.7801783), ('North America', 16.16828833), ('North Korea', 11.91595804), ('Northern Ireland', 15.97895436), ('Northern Mariana Islands', 11.068200099999999), ('Norway', 14.80513401), ('Oceania', 11.13128848), ('Oman', 13.46183451), ('Pakistan', 11.52209368), ('Palestine', 15.70642814), ('Panama', 10.70246104), ('Papua New Guinea', 11.15925308), ('Paraguay', 12.95005176), ('Peru', 11.71555393), ('Philippines', 10.39104478), ('Poland', 11.06641284), ('Portugal', 13.91262674), ('Puerto Rico', 13.61382087), ('Qatar', 13.59611741), ('Romania', 10.77483797), ('Russia', 11.61144037), ('Rwanda', 12.04162058), ('Saint Lucia', 13.48582736), ('Saint Vincent and the Grenadines', 13.474190599999998), ('Samoa', 10.85143129), ('Sao Tome and Principe', 11.41433574), ('Saudi Arabia', 13.25645543), ('Scotland', 13.44656424), ('Senegal', 11.69102167), ('Serbia', 11.01673013), ('Seychelles', 10.52810266), ('Sierra Leone', 11.68906926), ('Singapore', 12.0350557), ('Slovakia', 10.89585216), ('Slovenia', 11.33071529), ('Solomon Islands', 11.229545199999999), ('Somalia', 12.5931244), ('South Africa', 12.75893546), ('South Asia', 13.83438991), ('South Korea', 11.06356522), ('South Sudan', 11.85204781), ('Southeast Asia', 10.33147405), ('Southeast Asia, East Asia, and Oceania', 11.00054655), ('Southern Latin America', 13.77690148), ('Southern Sub-Saharan Africa', 12.76207642), ('Spain', 14.45882611), ('Sri Lanka', 11.15209358), ('Sub-Saharan Africa', 12.14966965), ('Sudan', 15.92035535), ('Suriname', 14.03425226), ('Swaziland', 13.06597094), ('Sweden', 14.04922185), ('Switzerland', 13.5581555), ('Syria', 14.45703852), ('Taiwan', 11.62466188), ('Tajikistan', 10.64944954), ('Tanzania', 11.85559758), ('Thailand', 11.91876723), ('Timor', 11.09480421), ('Togo', 11.84631867), ('Tonga', 10.75631418), ('Trinidad and Tobago', 13.89919098), ('Tropical Latin America', 13.087585800000001), ('Tunisia', 15.05246048), ('Turkey', 14.19673292), ('Turkmenistan', 10.60866465), ('Uganda', 12.97685878), ('Ukraine', 12.07512714), ('United Arab Emirates', 12.32482273), ('United Kingdom', 14.033961699999999), ('United States', 16.26387429), ('United States Virgin Islands', 13.63259525), ('Uruguay', 13.77504167), ('Uzbekistan', 10.73137001), ('Vanuatu', 11.08565901), ('Venezuela', 11.18188559), ('Vietnam', 8.988939185), ('Wales', 13.80581111), ('Western Europe', 13.86118205), ('Western Sub-Saharan Africa', 11.80157631), ('World', 12.58119894), ('Yemen', 15.51480665), ('Zambia', 12.04729227), ('Zimbabwe', 12.56106349)]
In [40]:
import pandas as pd
import numpy as np
from pyecharts.charts import Geo
from pyecharts import options as opts
from pyecharts.globals import ChartType, SymbolType,ThemeType
from pyecharts.charts import Bar,Tab,Line,Map,Timeline

def timeline_map() -> Timeline:
    tl = Timeline()
    for i in range(2014,2018):
        map0 = (
            Map()
            .add(
                "男性患病率",list(zip(list(df.Country),list(df["{}年".format(i)]))),"world",is_map_symbol_show = False
            )
            .set_global_opts(
                title_opts=opts.TitleOpts(title="{}年男性患病率".format(i),subtitle="",
                                          subtitle_textstyle_opts=opts.TextStyleOpts(color="red",font_size=18,font_style="italic")),
                visualmap_opts=opts.VisualMapOpts(min_= 8.96,max_=17.6)
            
            )
        )
        tl.add(map0,"{}年".format(i))
    return tl
timeline_map().render_notebook()
Out[40]:

由地图可知2014年-2017年亚洲、俄罗斯及部门南美洲地区的男性心理健康患病率比欧洲、美国、澳洲要低,由此可见发达国家和地区患心理健康疾病的比例也比欠发达的国家和地区高。且四年间的变化率不大,相对于较稳定趋势。

In [41]:
df = pd.read_csv('country_females.csv',encoding='gbk')
In [42]:
df
Out[42]:
Country 2014年 2015年 2016年 2017年
0 Afghanistan 17.085561 17.041232 17.002182 16.963023
1 Albania 11.065094 11.058989 11.045554 11.043173
2 Algeria 14.980180 14.986809 14.994890 15.011597
3 American Samoa 11.007858 11.007287 11.002724 11.004269
4 Andean Latin America 12.789837 12.789660 12.788287 12.787111
5 Andorra 15.846479 15.850925 15.855442 15.861840
6 Angola 12.328792 12.327245 12.322599 12.322946
7 Antigua and Barbuda 13.368135 13.375635 13.381903 13.392391
8 Argentina 17.564053 17.573386 17.583533 17.598748
9 Armenia 10.547196 10.553468 10.564378 10.574900
10 Australasia 19.471482 19.436418 19.395227 19.354329
11 Australia 19.352941 19.311627 19.264186 19.216194
12 Austria 15.589555 15.589782 15.591026 15.600716
13 Azerbaijan 10.368040 10.377675 10.396507 10.416485
14 Bahamas 13.478457 13.481507 13.487294 13.491201
15 Bahrain 14.850438 14.833887 14.822228 14.816274
16 Bangladesh 13.467970 13.408453 13.348796 13.289032
17 Barbados 13.590267 13.596185 13.596342 13.602635
18 Belarus 12.098269 12.091812 12.087286 12.081957
19 Belgium 15.630786 15.639846 15.643901 15.653381
20 Belize 13.461596 13.465908 13.468690 13.472870
21 Benin 11.688219 11.691759 11.690371 11.693028
22 Bermuda 13.915670 13.910826 13.907828 13.902880
23 Bhutan 12.208802 12.216368 12.229395 12.241409
24 Bolivia 13.346936 13.339368 13.324520 13.311968
25 Bosnia and Herzegovina 11.109441 11.103246 11.093431 11.091413
26 Botswana 12.137819 12.132886 12.128188 12.127932
27 Brazil 16.073385 15.980628 15.886907 15.792622
28 Brunei 11.705006 11.713503 11.730316 11.743905
29 Bulgaria 11.379093 11.377511 11.372656 11.374022
... ... ... ... ... ...
201 Taiwan 11.352653 11.348627 11.344796 11.338834
202 Tajikistan 10.688414 10.676713 10.667650 10.659094
203 Tanzania 12.824194 12.834891 12.845311 12.857774
204 Thailand 11.622408 11.602588 11.589454 11.578325
205 Timor 12.280247 12.233449 12.188151 12.164470
206 Togo 11.660370 11.654846 11.647139 11.644117
207 Tonga 11.137072 11.131282 11.127248 11.120704
208 Trinidad and Tobago 14.139536 14.140235 14.138539 14.133760
209 Tropical Latin America 16.054149 15.963876 15.872559 15.780627
210 Tunisia 15.474682 15.467767 15.463897 15.465274
211 Turkey 14.424071 14.398836 14.377817 14.355624
212 Turkmenistan 10.598133 10.601733 10.607301 10.613201
213 Uganda 13.930397 13.883849 13.835766 13.790202
214 Ukraine 12.035598 12.015691 12.002457 11.993509
215 United Arab Emirates 12.982289 12.985515 12.981067 12.977993
216 United Kingdom 15.209811 15.213827 15.216007 15.216455
217 United States 18.293735 18.304311 18.321319 18.347446
218 United States Virgin Islands 13.922081 13.918943 13.904578 13.892177
219 Uruguay 17.466979 17.494140 17.524876 17.557468
220 Uzbekistan 10.642068 10.637069 10.630145 10.625033
221 Vanuatu 11.335068 11.330315 11.326689 11.318353
222 Venezuela 10.997758 11.002820 11.002089 11.003374
223 Vietnam 10.413027 10.385800 10.359497 10.346828
224 Wales 15.191740 15.206088 15.227745 15.248820
225 Western Europe 16.679503 16.676422 16.674511 16.669722
226 Western Sub-Saharan Africa 11.918384 11.883468 11.846144 11.802223
227 World 13.288238 13.273091 13.259132 13.245729
228 Yemen 16.230133 16.247524 16.267155 16.296067
229 Zambia 12.421706 12.449468 12.485455 12.528861
230 Zimbabwe 10.698576 10.709341 10.728702 10.740696

231 rows × 5 columns

In [43]:
for i in range(2014,2018):
    print(list(zip(list(df.Country),list(df["{}年".format(i)]))))
[('Afghanistan', 17.08556095), ('Albania', 11.06509446), ('Algeria', 14.9801801), ('American Samoa', 11.00785834), ('Andean Latin America', 12.78983672), ('Andorra', 15.8464789), ('Angola', 12.32879173), ('Antigua and Barbuda', 13.36813484), ('Argentina', 17.564053), ('Armenia', 10.54719553), ('Australasia', 19.47148217), ('Australia', 19.35294106), ('Austria', 15.58955485), ('Azerbaijan', 10.36804019), ('Bahamas', 13.4784566), ('Bahrain', 14.85043772), ('Bangladesh', 13.46797023), ('Barbados', 13.59026728), ('Belarus', 12.09826934), ('Belgium', 15.63078606), ('Belize', 13.46159557), ('Benin', 11.68821929), ('Bermuda', 13.91567014), ('Bhutan', 12.20880225), ('Bolivia', 13.34693612), ('Bosnia and Herzegovina', 11.10944104), ('Botswana', 12.13781927), ('Brazil', 16.07338495), ('Brunei', 11.70500608), ('Bulgaria', 11.37909341), ('Burkina Faso', 11.63588453), ('Burundi', 13.30031967), ('Cambodia', 12.01212422), ('Cameroon', 11.76661899), ('Canada', 15.58759443), ('Cape Verde', 11.91864496), ('Caribbean', 13.86154011), ('Central African Republic', 12.53674819), ('Central Asia', 10.74605766), ('Central Europe', 11.08405871), ('Central Europe, Eastern Europe, and Central Asia', 11.35456446), ('Central Latin America', 10.85273094), ('Central Sub-Saharan Africa', 12.37874564), ('Chad', 12.15723494), ('Chile', 17.96308737), ('China', 11.48426535), ('Colombia', 9.632327983), ('Comoros', 12.61376748), ('Congo', 12.33148289), ('Costa Rica', 11.03708169), ("Cote d'Ivoire", 11.28995946), ('Croatia', 11.48264852), ('Cuba', 14.18037979), ('Cyprus', 15.26030381), ('Czech Republic', 11.37163817), ('Democratic Republic of Congo', 12.39542441), ('Denmark', 15.19892891), ('Djibouti', 12.90746703), ('Dominica', 13.32992407), ('Dominican Republic', 13.83403312), ('East Asia', 11.484414), ('Eastern Europe', 11.75255368), ('Eastern Sub-Saharan Africa', 13.05691123), ('Ecuador', 13.15445316), ('Egypt', 14.91369743), ('El Salvador', 11.14779666), ('England', 15.08792628), ('Equatorial Guinea', 12.36468135), ('Eritrea', 13.13257283), ('Estonia', 12.16714119), ('Ethiopia', 13.17492583), ('Fiji', 11.26595207), ('Finland', 15.24382339), ('France', 18.42542302), ('Gabon', 12.12128424), ('Gambia', 12.84794201), ('Georgia', 10.63516604), ('Germany', 17.05964959), ('Ghana', 11.23317079), ('Greece', 17.01410035), ('Greenland', 18.96616248), ('Grenada', 13.38025545), ('Guam', 11.40425186), ('Guatemala', 11.45754852), ('Guinea', 11.67693218), ('Guinea-Bissau', 11.75074964), ('Guyana', 14.89603738), ('Haiti', 13.71900994), ('High SDI', 15.70781801), ('High-income', 16.52843241), ('High-income Asia Pacific', 12.14833066), ('High-middle SDI', 12.973338499999999), ('Honduras', 10.82531736), ('Hungary', 11.465229699999998), ('Iceland', 15.30060223), ('India', 14.58751197), ('Indonesia', 11.15776595), ('Iran', 18.46044898), ('Iraq', 14.82691636), ('Ireland', 16.75541213), ('Israel', 13.23209279), ('Italy', 16.01317492), ('Jamaica', 13.3397345), ('Japan', 12.00794468), ('Jordan', 14.81260653), ('Kazakhstan', 11.11179553), ('Kenya', 12.66404014), ('Kiribati', 11.35497111), ('Kuwait', 14.81970221), ('Kyrgyzstan', 10.91394311), ('Laos', 12.50778588), ('Latin America and Caribbean', 13.32469336), ('Latvia', 11.44992698), ('Lebanon', 16.78971421), ('Lesotho', 13.89377353), ('Liberia', 12.70904868), ('Libya', 14.92395859), ('Lithuania', 12.15313438), ('Low SDI', 13.78173952), ('Low-middle SDI', 13.60106231), ('Luxembourg', 15.82314335), ('Macedonia', 11.15043352), ('Madagascar', 12.94608303), ('Malawi', 12.51908061), ('Malaysia', 12.88767593), ('Maldives', 11.74590044), ('Mali', 11.07997252), ('Malta', 15.36658548), ('Marshall Islands', 11.29662578), ('Mauritania', 10.95288213), ('Mauritius', 11.85798554), ('Mexico', 11.23854226), ('Micronesia (country)', 11.30163585), ('Middle SDI', 12.09021902), ('Moldova', 11.48335119), ('Mongolia', 11.13048797), ('Montenegro', 11.39724837), ('Morocco', 17.0540544), ('Mozambique', 13.02699958), ('Myanmar', 10.85637376), ('Namibia', 11.42149458), ('Nepal', 13.18940849), ('Netherlands', 17.29369285), ('New Zealand', 20.07164768), ('Nicaragua', 11.00113084), ('Niger', 11.97794866), ('Nigeria', 12.31456509), ('North Africa and Middle East', 15.811789000000001), ('North America', 18.0277736), ('North Korea', 11.63529289), ('Northern Ireland', 19.00262748), ('Northern Mariana Islands', 11.007330300000001), ('Norway', 17.29037397), ('Oceania', 11.49313336), ('Oman', 14.44350766), ('Pakistan', 12.45835737), ('Palestine', 16.25876809), ('Panama', 10.79401557), ('Papua New Guinea', 11.54791281), ('Paraguay', 15.40613262), ('Peru', 12.43431439), ('Philippines', 11.273072099999998), ('Poland', 10.8444472), ('Portugal', 16.76627267), ('Puerto Rico', 13.46867686), ('Qatar', 14.68837377), ('Romania', 10.79198582), ('Russia', 11.63744415), ('Rwanda', 13.154594699999999), ('Saint Lucia', 13.49827644), ('Saint Vincent and the Grenadines', 13.37238501), ('Samoa', 11.10760141), ('Sao Tome and Principe', 11.23567579), ('Saudi Arabia', 14.27178571), ('Scotland', 15.08036893), ('Senegal', 11.15388249), ('Serbia', 11.310729400000001), ('Seychelles', 11.08355067), ('Sierra Leone', 11.82458013), ('Singapore', 12.81949454), ('Slovakia', 11.17661205), ('Slovenia', 11.74992431), ('Solomon Islands', 11.56064047), ('Somalia', 13.8338881), ('South Africa', 12.66928916), ('South Asia', 14.18542108), ('South Korea', 12.43937347), ('South Sudan', 12.8319849), ('Southeast Asia', 11.23091253), ('Southeast Asia, East Asia, and Oceania', 11.43873612), ('Southern Latin America', 17.67024528), ('Southern Sub-Saharan Africa', 12.30090412), ('Spain', 17.76147156), ('Sri Lanka', 11.86350377), ('Sub-Saharan Africa', 12.41963738), ('Sudan', 16.21891755), ('Suriname', 14.71018869), ('Swaziland', 11.97373439), ('Sweden', 17.08805091), ('Switzerland', 16.11780089), ('Syria', 15.11277311), ('Taiwan', 11.35265277), ('Tajikistan', 10.68841414), ('Tanzania', 12.8241939), ('Thailand', 11.62240806), ('Timor', 12.28024655), ('Togo', 11.66037037), ('Tonga', 11.137072300000002), ('Trinidad and Tobago', 14.13953557), ('Tropical Latin America', 16.05414877), ('Tunisia', 15.47468194), ('Turkey', 14.42407075), ('Turkmenistan', 10.59813308), ('Uganda', 13.93039659), ('Ukraine', 12.03559817), ('United Arab Emirates', 12.98228907), ('United Kingdom', 15.20981111), ('United States', 18.29373474), ('United States Virgin Islands', 13.92208138), ('Uruguay', 17.46697911), ('Uzbekistan', 10.64206847), ('Vanuatu', 11.33506779), ('Venezuela', 10.99775797), ('Vietnam', 10.41302677), ('Wales', 15.19174013), ('Western Europe', 16.67950296), ('Western Sub-Saharan Africa', 11.91838393), ('World', 13.28823829), ('Yemen', 16.23013339), ('Zambia', 12.42170615), ('Zimbabwe', 10.69857563)]
[('Afghanistan', 17.04123159), ('Albania', 11.05898907), ('Algeria', 14.98680857), ('American Samoa', 11.00728657), ('Andean Latin America', 12.78966008), ('Andorra', 15.85092539), ('Angola', 12.32724532), ('Antigua and Barbuda', 13.37563503), ('Argentina', 17.57338608), ('Armenia', 10.55346793), ('Australasia', 19.43641821), ('Australia', 19.31162687), ('Austria', 15.58978164), ('Azerbaijan', 10.37767506), ('Bahamas', 13.48150673), ('Bahrain', 14.83388721), ('Bangladesh', 13.40845331), ('Barbados', 13.59618453), ('Belarus', 12.09181166), ('Belgium', 15.63984601), ('Belize', 13.46590766), ('Benin', 11.69175908), ('Bermuda', 13.91082573), ('Bhutan', 12.21636758), ('Bolivia', 13.33936752), ('Bosnia and Herzegovina', 11.10324625), ('Botswana', 12.13288612), ('Brazil', 15.98062829), ('Brunei', 11.71350337), ('Bulgaria', 11.37751052), ('Burkina Faso', 11.65336127), ('Burundi', 13.29614687), ('Cambodia', 11.95728409), ('Cameroon', 11.75759742), ('Canada', 15.60581554), ('Cape Verde', 11.92664828), ('Caribbean', 13.853194400000001), ('Central African Republic', 12.53188381), ('Central Asia', 10.74211365), ('Central Europe', 11.07937311), ('Central Europe, Eastern Europe, and Central Asia', 11.35116846), ('Central Latin America', 10.85673833), ('Central Sub-Saharan Africa', 12.36348428), ('Chad', 12.14684423), ('Chile', 17.97997361), ('China', 11.44172054), ('Colombia', 9.626802857000001), ('Comoros', 12.63433271), ('Congo', 12.30342559), ('Costa Rica', 11.04821386), ("Cote d'Ivoire", 11.31328007), ('Croatia', 11.47940048), ('Cuba', 14.17526739), ('Cyprus', 15.27357845), ('Czech Republic', 11.36605273), ('Democratic Republic of Congo', 12.37553114), ('Denmark', 15.20322517), ('Djibouti', 12.91667752), ('Dominica', 13.3369473), ('Dominican Republic', 13.81494558), ('East Asia', 11.44339695), ('Eastern Europe', 11.75584313), ('Eastern Sub-Saharan Africa', 13.04739864), ('Ecuador', 13.16350094), ('Egypt', 14.895161100000001), ('El Salvador', 11.15137275), ('England', 15.09687251), ('Equatorial Guinea', 12.37488853), ('Eritrea', 13.13339732), ('Estonia', 12.13682776), ('Ethiopia', 13.15561085), ('Fiji', 11.26756938), ('Finland', 15.22297279), ('France', 18.39346095), ('Gabon', 12.11955986), ('Gambia', 12.85864818), ('Georgia', 10.62895059), ('Germany', 17.07222876), ('Ghana', 11.23945494), ('Greece', 16.99186229), ('Greenland', 18.93264181), ('Grenada', 13.38399649), ('Guam', 11.39938801), ('Guatemala', 11.4283476), ('Guinea', 11.67091734), ('Guinea-Bissau', 11.7506278), ('Guyana', 14.87592012), ('Haiti', 13.70668715), ('High SDI', 15.72408152), ('High-income', 16.54555277), ('High-income Asia Pacific', 12.18656157), ('High-middle SDI', 12.95866274), ('Honduras', 10.82948807), ('Hungary', 11.47133144), ('Iceland', 15.30999554), ('India', 14.578340099999998), ('Indonesia', 11.12941659), ('Iran', 18.44580534), ('Iraq', 14.84367268), ('Ireland', 16.74250888), ('Israel', 13.18353904), ('Italy', 16.01885689), ('Jamaica', 13.34936337), ('Japan', 12.04650823), ('Jordan', 14.80597552), ('Kazakhstan', 11.11258317), ('Kenya', 12.65742289), ('Kiribati', 11.34962025), ('Kuwait', 14.82875499), ('Kyrgyzstan', 10.90447833), ('Laos', 12.45882617), ('Latin America and Caribbean', 13.28518235), ('Latvia', 11.45276546), ('Lebanon', 16.76555856), ('Lesotho', 13.88832992), ('Liberia', 12.70895508), ('Libya', 14.95075317), ('Lithuania', 12.14959093), ('Low SDI', 13.75747408), ('Low-middle SDI', 13.57095182), ('Luxembourg', 15.82730838), ('Macedonia', 11.14716055), ('Madagascar', 12.94244631), ('Malawi', 12.54669786), ('Malaysia', 12.87614956), ('Maldives', 11.71328444), ('Mali', 11.09483573), ('Malta', 15.38739178), ('Marshall Islands', 11.29368274), ('Mauritania', 10.97112565), ('Mauritius', 11.83101152), ('Mexico', 11.24883863), ('Micronesia (country)', 11.29505054), ('Middle SDI', 12.07642404), ('Moldova', 11.47644231), ('Mongolia', 11.11988022), ('Montenegro', 11.38894447), ('Morocco', 16.9875338), ('Mozambique', 13.02839807), ('Myanmar', 10.81291681), ('Namibia', 11.43594065), ('Nepal', 13.1294337), ('Netherlands', 17.31961801), ('New Zealand', 20.07527465), ('Nicaragua', 11.00058335), ('Niger', 11.97832949), ('Nigeria', 12.23187035), ('North Africa and Middle East', 15.79619992), ('North America', 18.03931677), ('North Korea', 11.63715895), ('Northern Ireland', 18.83534447), ('Northern Mariana Islands', 11.00565333), ('Norway', 17.33261021), ('Oceania', 11.47501858), ('Oman', 14.45560152), ('Pakistan', 12.44390191), ('Palestine', 16.21274044), ('Panama', 10.80721042), ('Papua New Guinea', 11.52465074), ('Paraguay', 15.41241974), ('Peru', 12.43184844), ('Philippines', 11.251221800000001), ('Poland', 10.83154037), ('Portugal', 16.69608786), ('Puerto Rico', 13.4801573), ('Qatar', 14.69193372), ('Romania', 10.79402323), ('Russia', 11.64995613), ('Rwanda', 13.16916418), ('Saint Lucia', 13.50280161), ('Saint Vincent and the Grenadines', 13.37613765), ('Samoa', 11.10115723), ('Sao Tome and Principe', 11.24529919), ('Saudi Arabia', 14.28440005), ('Scotland', 15.08931467), ('Senegal', 11.18176874), ('Serbia', 11.30855972), ('Seychelles', 11.07891175), ('Sierra Leone', 11.81150856), ('Singapore', 12.81789866), ('Slovakia', 11.17547921), ('Slovenia', 11.74235047), ('Solomon Islands', 11.54384229), ('Somalia', 13.73265334), ('South Africa', 12.67546716), ('South Asia', 14.16855339), ('South Korea', 12.47433986), ('South Sudan', 12.8380209), ('Southeast Asia', 11.20280725), ('Southeast Asia, East Asia, and Oceania', 11.40090795), ('Southern Latin America', 17.68212403), ('Southern Sub-Saharan Africa', 12.30335021), ('Spain', 17.77679358), ('Sri Lanka', 11.82123437), ('Sub-Saharan Africa', 12.3994728), ('Sudan', 16.21404621), ('Suriname', 14.70555246), ('Swaziland', 11.9784347), ('Sweden', 17.08094663), ('Switzerland', 16.11408377), ('Syria', 15.129428), ('Taiwan', 11.34862742), ('Tajikistan', 10.67671269), ('Tanzania', 12.83489087), ('Thailand', 11.60258762), ('Timor', 12.23344899), ('Togo', 11.65484564), ('Tonga', 11.13128195), ('Trinidad and Tobago', 14.14023535), ('Tropical Latin America', 15.96387612), ('Tunisia', 15.46776713), ('Turkey', 14.39883626), ('Turkmenistan', 10.60173329), ('Uganda', 13.88384851), ('Ukraine', 12.01569106), ('United Arab Emirates', 12.985515), ('United Kingdom', 15.21382671), ('United States', 18.30431071), ('United States Virgin Islands', 13.91894284), ('Uruguay', 17.4941402), ('Uzbekistan', 10.63706923), ('Vanuatu', 11.33031515), ('Venezuela', 11.00281995), ('Vietnam', 10.38579953), ('Wales', 15.20608772), ('Western Europe', 16.67642179), ('Western Sub-Saharan Africa', 11.88346824), ('World', 13.27309115), ('Yemen', 16.24752402), ('Zambia', 12.44946808), ('Zimbabwe', 10.70934073)]
[('Afghanistan', 17.00218203), ('Albania', 11.04555426), ('Algeria', 14.99488952), ('American Samoa', 11.00272418), ('Andean Latin America', 12.78828692), ('Andorra', 15.85544215), ('Angola', 12.32259927), ('Antigua and Barbuda', 13.38190308), ('Argentina', 17.58353313), ('Armenia', 10.56437823), ('Australasia', 19.39522744), ('Australia', 19.26418635), ('Austria', 15.59102598), ('Azerbaijan', 10.39650695), ('Bahamas', 13.48729409), ('Bahrain', 14.82222768), ('Bangladesh', 13.34879581), ('Barbados', 13.59634213), ('Belarus', 12.08728599), ('Belgium', 15.64390109), ('Belize', 13.46868986), ('Benin', 11.69037073), ('Bermuda', 13.90782755), ('Bhutan', 12.22939543), ('Bolivia', 13.32452034), ('Bosnia and Herzegovina', 11.09343139), ('Botswana', 12.12818832), ('Brazil', 15.88690681), ('Brunei', 11.730316199999999), ('Bulgaria', 11.37265632), ('Burkina Faso', 11.6735383), ('Burundi', 13.30293926), ('Cambodia', 11.9083853), ('Cameroon', 11.75870492), ('Canada', 15.63876401), ('Cape Verde', 11.93298973), ('Caribbean', 13.84329507), ('Central African Republic', 12.52847966), ('Central Asia', 10.74163945), ('Central Europe', 11.07898906), ('Central Europe, Eastern Europe, and Central Asia', 11.35163322), ('Central Latin America', 10.8631089), ('Central Sub-Saharan Africa', 12.35161213), ('Chad', 12.13670868), ('Chile', 18.00337628), ('China', 11.39733557), ('Colombia', 9.625504409), ('Comoros', 12.66536092), ('Congo', 12.2741678), ('Costa Rica', 11.05554876), ("Cote d'Ivoire", 11.33917175), ('Croatia', 11.47674741), ('Cuba', 14.172139999999999), ('Cyprus', 15.295353699999998), ('Czech Republic', 11.36152757), ('Democratic Republic of Congo', 12.36157261), ('Denmark', 15.20988452), ('Djibouti', 12.92327875), ('Dominica', 13.34736067), ('Dominican Republic', 13.79354897), ('East Asia', 11.40060649), ('Eastern Europe', 11.76426092), ('Eastern Sub-Saharan Africa', 13.04058679), ('Ecuador', 13.16929306), ('Egypt', 14.87237139), ('El Salvador', 11.15421783), ('England', 15.10480558), ('Equatorial Guinea', 12.38498753), ('Eritrea', 13.14219267), ('Estonia', 12.11237189), ('Ethiopia', 13.14283151), ('Fiji', 11.26860138), ('Finland', 15.19947877), ('France', 18.36053019), ('Gabon', 12.11904206), ('Gambia', 12.87632545), ('Georgia', 10.62533878), ('Germany', 17.08601202), ('Ghana', 11.24777417), ('Greece', 16.97137764), ('Greenland', 18.88850525), ('Grenada', 13.39079721), ('Guam', 11.3936007), ('Guatemala', 11.40363727), ('Guinea', 11.6697564), ('Guinea-Bissau', 11.74559805), ('Guyana', 14.84643641), ('Haiti', 13.68671578), ('High SDI', 15.74420173), ('High-income', 16.56570409), ('High-income Asia Pacific', 12.22746323), ('High-middle SDI', 12.94294634), ('Honduras', 10.83581472), ('Hungary', 11.4831874), ('Iceland', 15.31906977), ('India', 14.57293018), ('Indonesia', 11.10425185), ('Iran', 18.41754239), ('Iraq', 14.86424871), ('Ireland', 16.72917805), ('Israel', 13.12360566), ('Italy', 16.03008006), ('Jamaica', 13.36079193), ('Japan', 12.0869274), ('Jordan', 14.80128188), ('Kazakhstan', 11.12129161), ('Kenya', 12.65421265), ('Kiribati', 11.34559262), ('Kuwait', 14.83974952), ('Kyrgyzstan', 10.90333669), ('Laos', 12.419564999999999), ('Latin America and Caribbean', 13.24604883), ('Latvia', 11.45754027), ('Lebanon', 16.72888373), ('Lesotho', 13.88637038), ('Liberia', 12.70813718), ('Libya', 14.98324496), ('Lithuania', 12.15150879), ('Low SDI', 13.73277205), ('Low-middle SDI', 13.54203547), ('Luxembourg', 15.833039499999998), ('Macedonia', 11.14514949), ('Madagascar', 12.95233282), ('Malawi', 12.5758552), ('Malaysia', 12.86970882), ('Maldives', 11.68662788), ('Mali', 11.11003883), ('Malta', 15.41195154), ('Marshall Islands', 11.27742617), ('Mauritania', 10.99702431), ('Mauritius', 11.80360278), ('Mexico', 11.26254944), ('Micronesia (country)', 11.27987957), ('Middle SDI', 12.06363026), ('Moldova', 11.47262711), ('Mongolia', 11.11696537), ('Montenegro', 11.37715002), ('Morocco', 16.91406701), ('Mozambique', 13.02791512), ('Myanmar', 10.78032372), ('Namibia', 11.45166801), ('Nepal', 13.06634926), ('Netherlands', 17.35618529), ('New Zealand', 20.07409026), ('Nicaragua', 11.00553286), ('Niger', 11.97898012), ('Nigeria', 12.14162811), ('North Africa and Middle East', 15.77925432), ('North America', 18.05806252), ('North Korea', 11.63925704), ('Northern Ireland', 18.65269609), ('Northern Mariana Islands', 11.00141243), ('Norway', 17.38268333), ('Oceania', 11.45428933), ('Oman', 14.46550437), ('Pakistan', 12.43235855), ('Palestine', 16.15536666), ('Panama', 10.82541884), ('Papua New Guinea', 11.49853144), ('Paraguay', 15.41372278), ('Peru', 12.43026911), ('Philippines', 11.23095841), ('Poland', 10.82965151), ('Portugal', 16.62825065), ('Puerto Rico', 13.49490718), ('Qatar', 14.69975598), ('Romania', 10.79633631), ('Russia', 11.66722744), ('Rwanda', 13.18795676), ('Saint Lucia', 13.50422605), ('Saint Vincent and the Grenadines', 13.37455344), ('Samoa', 11.09144479), ('Sao Tome and Principe', 11.2511991), ('Saudi Arabia', 14.30205821), ('Scotland', 15.08760199), ('Senegal', 11.20992184), ('Serbia', 11.309071800000002), ('Seychelles', 11.07425995), ('Sierra Leone', 11.79944645), ('Singapore', 12.81862776), ('Slovakia', 11.17732283), ('Slovenia', 11.73504696), ('Solomon Islands', 11.52643094), ('Somalia', 13.60078323), ('South Africa', 12.68336805), ('South Asia', 14.15399379), ('South Korea', 12.51254632), ('South Sudan', 12.84915342), ('Southeast Asia', 11.178779800000001), ('Southeast Asia, East Asia, and Oceania', 11.36334388), ('Southern Latin America', 17.69665441), ('Southern Sub-Saharan Africa', 12.30918393), ('Spain', 17.792976), ('Sri Lanka', 11.77984105), ('Sub-Saharan Africa', 12.38014173), ('Sudan', 16.20578193), ('Suriname', 14.69441162), ('Swaziland', 11.98993742), ('Sweden', 17.07029802), ('Switzerland', 16.11462988), ('Syria', 15.14917245), ('Taiwan', 11.34479631), ('Tajikistan', 10.66765035), ('Tanzania', 12.84531097), ('Thailand', 11.58945392), ('Timor', 12.18815113), ('Togo', 11.64713921), ('Tonga', 11.127248300000002), ('Trinidad and Tobago', 14.13853862), ('Tropical Latin America', 15.87255877), ('Tunisia', 15.46389664), ('Turkey', 14.37781722), ('Turkmenistan', 10.60730075), ('Uganda', 13.83576608), ('Ukraine', 12.00245733), ('United Arab Emirates', 12.9810669), ('United Kingdom', 15.21600677), ('United States', 18.321319100000004), ('United States Virgin Islands', 13.90457778), ('Uruguay', 17.52487641), ('Uzbekistan', 10.63014456), ('Vanuatu', 11.326688800000001), ('Venezuela', 11.00208908), ('Vietnam', 10.35949716), ('Wales', 15.22774474), ('Western Europe', 16.67451088), ('Western Sub-Saharan Africa', 11.84614427), ('World', 13.25913163), ('Yemen', 16.26715494), ('Zambia', 12.48545528), ('Zimbabwe', 10.72870234)]
[('Afghanistan', 16.96302255), ('Albania', 11.04317255), ('Algeria', 15.01159706), ('American Samoa', 11.00426893), ('Andean Latin America', 12.78711135), ('Andorra', 15.86184049), ('Angola', 12.32294585), ('Antigua and Barbuda', 13.39239094), ('Argentina', 17.59874775), ('Armenia', 10.57489953), ('Australasia', 19.35432947), ('Australia', 19.21619405), ('Austria', 15.60071603), ('Azerbaijan', 10.41648516), ('Bahamas', 13.49120068), ('Bahrain', 14.81627383), ('Bangladesh', 13.28903163), ('Barbados', 13.6026348), ('Belarus', 12.08195744), ('Belgium', 15.65338106), ('Belize', 13.47286976), ('Benin', 11.693028199999999), ('Bermuda', 13.90287959), ('Bhutan', 12.24140941), ('Bolivia', 13.31196751), ('Bosnia and Herzegovina', 11.09141289), ('Botswana', 12.12793237), ('Brazil', 15.79262155), ('Brunei', 11.74390488), ('Bulgaria', 11.37402183), ('Burkina Faso', 11.69866487), ('Burundi', 13.31775657), ('Cambodia', 11.86483359), ('Cameroon', 11.75166617), ('Canada', 15.67775188), ('Cape Verde', 11.94527944), ('Caribbean', 13.83525884), ('Central African Republic', 12.52543399), ('Central Asia', 10.74032131), ('Central Europe', 11.07793467), ('Central Europe, Eastern Europe, and Central Asia', 11.35330022), ('Central Latin America', 10.87214112), ('Central Sub-Saharan Africa', 12.334849499999999), ('Chad', 12.13279508), ('Chile', 18.03206451), ('China', 11.349312699999999), ('Colombia', 9.632960357), ('Comoros', 12.69160245), ('Congo', 12.24803579), ('Costa Rica', 11.063826400000002), ("Cote d'Ivoire", 11.36639947), ('Croatia', 11.47753656), ('Cuba', 14.17651035), ('Cyprus', 15.31440481), ('Czech Republic', 11.35739402), ('Democratic Republic of Congo', 12.338106100000001), ('Denmark', 15.22011944), ('Djibouti', 12.93323532), ('Dominica', 13.36071525), ('Dominican Republic', 13.77695698), ('East Asia', 11.35417594), ('Eastern Europe', 11.77542009), ('Eastern Sub-Saharan Africa', 13.03665488), ('Ecuador', 13.17278014), ('Egypt', 14.85395534), ('El Salvador', 11.16447313), ('England', 15.11067396), ('Equatorial Guinea', 12.39682448), ('Eritrea', 13.15261887), ('Estonia', 12.09143264), ('Ethiopia', 13.13708633), ('Fiji', 11.26542022), ('Finland', 15.17243141), ('France', 18.31508867), ('Gabon', 12.11815789), ('Gambia', 12.89069875), ('Georgia', 10.62417976), ('Germany', 17.10398727), ('Ghana', 11.26053647), ('Greece', 16.94804923), ('Greenland', 18.84740954), ('Grenada', 13.39492198), ('Guam', 11.38931274), ('Guatemala', 11.38034381), ('Guinea', 11.66951167), ('Guinea-Bissau', 11.74603891), ('Guyana', 14.81224657), ('Haiti', 13.66708124), ('High SDI', 15.76582463), ('High-income', 16.58878473), ('High-income Asia Pacific', 12.26919107), ('High-middle SDI', 12.92406777), ('Honduras', 10.84039681), ('Hungary', 11.49333065), ('Iceland', 15.32941138), ('India', 14.57455363), ('Indonesia', 11.0848362), ('Iran', 18.37477299), ('Iraq', 14.88806445), ('Ireland', 16.71311162), ('Israel', 13.06232688), ('Italy', 16.03737831), ('Jamaica', 13.37008289), ('Japan', 12.12948742), ('Jordan', 14.80317577), ('Kazakhstan', 11.12340044), ('Kenya', 12.65522997), ('Kiribati', 11.34281384), ('Kuwait', 14.84669463), ('Kyrgyzstan', 10.90026083), ('Laos', 12.38845661), ('Latin America and Caribbean', 13.20807069), ('Latvia', 11.46447251), ('Lebanon', 16.69713438), ('Lesotho', 13.88127814), ('Liberia', 12.71138902), ('Libya', 15.01543172), ('Lithuania', 12.15796108), ('Low SDI', 13.71076578), ('Low-middle SDI', 13.51480553), ('Luxembourg', 15.83891198), ('Macedonia', 11.14472764), ('Madagascar', 12.955444199999999), ('Malawi', 12.62239116), ('Malaysia', 12.86586099), ('Maldives', 11.6660741), ('Mali', 11.13135319), ('Malta', 15.44068507), ('Marshall Islands', 11.26795078), ('Mauritania', 11.02407465), ('Mauritius', 11.77589263), ('Mexico', 11.27734572), ('Micronesia (country)', 11.27620695), ('Middle SDI', 12.05362494), ('Moldova', 11.47204216), ('Mongolia', 11.10974161), ('Montenegro', 11.36457134), ('Morocco', 16.83955197), ('Mozambique', 13.03402798), ('Myanmar', 10.75678611), ('Namibia', 11.47981766), ('Nepal', 13.00299634), ('Netherlands', 17.39198137), ('New Zealand', 20.07796042), ('Nicaragua', 11.00770166), ('Niger', 11.98280649), ('Nigeria', 12.03532903), ('North Africa and Middle East', 15.76453694), ('North America', 18.0854826), ('North Korea', 11.63719877), ('Northern Ireland', 18.45449437), ('Northern Mariana Islands', 11.00313247), ('Norway', 17.44120257), ('Oceania', 11.42883974), ('Oman', 14.48148729), ('Pakistan', 12.428950500000001), ('Palestine', 16.09246773), ('Panama', 10.84318046), ('Papua New Guinea', 11.46752376), ('Paraguay', 15.41172376), ('Peru', 12.42968215), ('Philippines', 11.21610424), ('Poland', 10.82358254), ('Portugal', 16.54852173), ('Puerto Rico', 13.50608769), ('Qatar', 14.70538057), ('Romania', 10.80038069), ('Russia', 11.68737421), ('Rwanda', 13.206261600000001), ('Saint Lucia', 13.51260182), ('Saint Vincent and the Grenadines', 13.38006202), ('Samoa', 11.08998763), ('Sao Tome and Principe', 11.2637118), ('Saudi Arabia', 14.32870148), ('Scotland', 15.09166848), ('Senegal', 11.24629095), ('Serbia', 11.30709206), ('Seychelles', 11.073687300000001), ('Sierra Leone', 11.79165668), ('Singapore', 12.81709577), ('Slovakia', 11.1766752), ('Slovenia', 11.73401618), ('Solomon Islands', 11.50176167), ('Somalia', 13.43980578), ('South Africa', 12.69554577), ('South Asia', 14.14478189), ('South Korea', 12.55000474), ('South Sudan', 12.86651345), ('Southeast Asia', 11.16085472), ('Southeast Asia, East Asia, and Oceania', 11.3252282), ('Southern Latin America', 17.71580083), ('Southern Sub-Saharan Africa', 12.31743926), ('Spain', 17.80454817), ('Sri Lanka', 11.74478956), ('Sub-Saharan Africa', 12.3589356), ('Sudan', 16.21379206), ('Suriname', 14.68237175), ('Swaziland', 12.000217999999998), ('Sweden', 17.05990517), ('Switzerland', 16.11898788), ('Syria', 15.1725894), ('Taiwan', 11.3388338), ('Tajikistan', 10.65909441), ('Tanzania', 12.85777367), ('Thailand', 11.57832474), ('Timor', 12.16446983), ('Togo', 11.64411736), ('Tonga', 11.12070429), ('Trinidad and Tobago', 14.13376015), ('Tropical Latin America', 15.78062659), ('Tunisia', 15.46527405), ('Turkey', 14.35562438), ('Turkmenistan', 10.6132007), ('Uganda', 13.79020212), ('Ukraine', 11.99350866), ('United Arab Emirates', 12.97799316), ('United Kingdom', 15.21645503), ('United States', 18.34744604), ('United States Virgin Islands', 13.89217659), ('Uruguay', 17.55746782), ('Uzbekistan', 10.62503286), ('Vanuatu', 11.31835322), ('Venezuela', 11.00337382), ('Vietnam', 10.34682823), ('Wales', 15.24882039), ('Western Europe', 16.66972185), ('Western Sub-Saharan Africa', 11.80222319), ('World', 13.24572917), ('Yemen', 16.29606734), ('Zambia', 12.52886108), ('Zimbabwe', 10.74069569)]
In [44]:
import pandas as pd
import numpy as np
from pyecharts.charts import Geo
from pyecharts import options as opts
from pyecharts.globals import ChartType, SymbolType,ThemeType
from pyecharts.charts import Bar,Tab,Line,Map,Timeline

def timeline_map() -> Timeline:
    tl = Timeline()
    for i in range(2014,2018):
        map0 = (
            Map()
            .add(
                "女性患病率",list(zip(list(df.Country),list(df["{}年".format(i)]))),"world",is_map_symbol_show = False
            )
            .set_global_opts(
                title_opts=opts.TitleOpts(title="{}年女性患病率".format(i),subtitle="",
                                          subtitle_textstyle_opts=opts.TextStyleOpts(color="red",font_size=18,font_style="italic")),
                visualmap_opts=opts.VisualMapOpts(min_= 10,max_=20)
            
            )
        )
        tl.add(map0,"{}年".format(i))
    return tl
timeline_map().render_notebook()
Out[44]:
  • 女性心理健康患病率在国家和地区间的分布大致同男性的差不多。经济较发达的欧洲、美洲及大洋洲的心理健康患病率的比例较高
  • 且四年间的变化趋势也趋于稳定,这与经济和社会发展水平有着密切联系,随着社会医疗保障体系的完善,心理健康患病率正趋于稳定和下降趋势。
In [150]:
import plotly as py

py.offline.init_notebook_mode()

中国男女性心理健康患病率

In [61]:
import pandas as pd
df = pd.read_csv('data_1.csv',encoding='gbk')
In [62]:
df.head(2)
Out[62]:
指标 2007年 2008年 2009年 2010年 2011年 2012年 2013年 2014年 2015年 2016年 2017年
0 CHNmales 11.420509 11.438862 11.452765 11.454783 11.447784 11.438664 11.426793 11.412147 11.394749 11.374748 11.352498
1 CHNfemales 11.632663 11.632112 11.628203 11.611661 11.585647 11.556362 11.522448 11.484265 11.441721 11.397336 11.349313
In [63]:
list(df.iloc[0])[1:]
Out[63]:
[11.420508900000002,
 11.438862400000001,
 11.45276503,
 11.45478285,
 11.44778355,
 11.43866391,
 11.42679288,
 11.41214671,
 11.39474934,
 11.37474847,
 11.35249761]
In [64]:
list(df.iloc[1])[1:]
Out[64]:
[11.63266274,
 11.63211239,
 11.62820258,
 11.61166116,
 11.58564658,
 11.55636216,
 11.52244813,
 11.48426535,
 11.44172054,
 11.39733557,
 11.349312699999999]
In [65]:
list(df.set_index('指标').columns)
Out[65]:
['2007年',
 '2008年',
 '2009年',
 '2010年',
 '2011年',
 '2012年',
 '2013年',
 '2014年',
 '2015年',
 '2016年',
 '2017年']
In [68]:
for i in range(2007,2017):
    print(list(zip(list(df.指标),list(df["{}年".format(i)]))))
[('CHNmales', 11.420508900000002), ('CHNfemales', 11.63266274), ('USmales', 16.49849931), ('USfemales', 18.50814858)]
[('CHNmales', 11.438862400000001), ('CHNfemales', 11.63211239), ('USmales', 16.42848063), ('USfemales', 18.42452656)]
[('CHNmales', 11.45276503), ('CHNfemales', 11.62820258), ('USmales', 16.36642072), ('USfemales', 18.34763062)]
[('CHNmales', 11.45478285), ('CHNfemales', 11.61166116), ('USmales', 16.33290129), ('USfemales', 18.30838166)]
[('CHNmales', 11.44778355), ('CHNfemales', 11.58564658), ('USmales', 16.32155897), ('USfemales', 18.29714292)]
[('CHNmales', 11.43866391), ('CHNfemales', 11.55636216), ('USmales', 16.30975748), ('USfemales', 18.28951618)]
[('CHNmales', 11.42679288), ('CHNfemales', 11.52244813), ('USmales', 16.29818911), ('USfemales', 18.28964709)]
[('CHNmales', 11.41214671), ('CHNfemales', 11.48426535), ('USmales', 16.28818571), ('USfemales', 18.29373474)]
[('CHNmales', 11.39474934), ('CHNfemales', 11.44172054), ('USmales', 16.27814981), ('USfemales', 18.30431071)]
[('CHNmales', 11.37474847), ('CHNfemales', 11.39733557), ('USmales', 16.27053323), ('USfemales', 18.321319100000004)]
In [76]:
from pyecharts.faker import Faker
from pyecharts import options as opts
from pyecharts.charts import Bar, Page, Pie, Timeline


def timeline_bar() -> Timeline:
    x = list(df.set_index('指标').columns)
    tl = Timeline()
    for i in range(2007, 2017):
        bar = (
            Bar()
            .add_xaxis(x)
            .add_yaxis("男性", list(df.iloc[0])[1:])
            .add_yaxis("女性", list(df.iloc[1])[1:])
            .set_global_opts(title_opts=opts.TitleOpts("中国男女性心理健康障碍患病率".format(i)))
        )
        tl.add(bar, "{}年".format(i))
    return tl
In [77]:
tl = timeline_bar()
tl.render_notebook()
Out[77]:

由我们国家2007年到2017年男女性心理健康患病率对比可知,女性虽还是比男性患病率比率高一点点,但两者已经不断趋平,且总体上患病率也逐年下降。这说明,我们国家的医疗普及水平,以及对心理健康的关怀程度不断提升,让国民心理健康得到更多保障。

中美男女性心理健康患病率比较

In [277]:
import pandas as pd
df = pd.read_csv("data_1.csv",encoding='ANSI')
In [279]:
df.head(4)
Out[279]:
指标 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
0 CHNmales 11.420509 11.438862 11.452765 11.454783 11.447784 11.438664 11.426793 11.412147 11.394749 11.374748 11.352498
1 CHNfemales 11.632663 11.632112 11.628203 11.611661 11.585647 11.556362 11.522448 11.484265 11.441721 11.397336 11.349313
2 USmales 16.498499 16.428481 16.366421 16.332901 16.321559 16.309757 16.298189 16.288186 16.278150 16.270533 16.263874
3 USfemales 18.508149 18.424527 18.347631 18.308382 18.297143 18.289516 18.289647 18.293735 18.304311 18.321319 18.347446
In [265]:
list(df.iloc[0])[1:]
Out[265]:
[11.420508900000002,
 11.438862400000001,
 11.45276503,
 11.45478285,
 11.44778355,
 11.43866391,
 11.42679288,
 11.41214671,
 11.39474934,
 11.37474847,
 11.35249761]
In [281]:
list(df.iloc[1])[1:]
Out[281]:
[11.63266274,
 11.63211239,
 11.62820258,
 11.61166116,
 11.58564658,
 11.55636216,
 11.52244813,
 11.48426535,
 11.44172054,
 11.39733557,
 11.349312699999999]
In [285]:
list(df.iloc[2])[1:]
Out[285]:
[16.49849931,
 16.42848063,
 16.36642072,
 16.33290129,
 16.32155897,
 16.30975748,
 16.29818911,
 16.28818571,
 16.27814981,
 16.27053323,
 16.26387429]
In [286]:
list(df.iloc[3])[1:]
Out[286]:
[18.50814858,
 18.42452656,
 18.34763062,
 18.30838166,
 18.29714292,
 18.28951618,
 18.28964709,
 18.29373474,
 18.30431071,
 18.321319100000004,
 18.34744604]
In [282]:
list(df.set_index('指标').columns)
Out[282]:
['2007',
 '2008',
 '2009',
 '2010',
 '2011',
 '2012',
 '2013',
 '2014',
 '2015',
 '2016',
 '2017']
In [291]:
from pyecharts import options as opts
from pyecharts.charts import Bar, Grid, Line,Scatter


def grid_vertical() -> Grid:
    bar = (
        Bar()
        .add_xaxis(list(df.set_index('指标').columns))
        .add_yaxis("中国男性", list(df.iloc[0])[1:])
        .add_yaxis("中国女性", list(df.iloc[1])[1:])
        .add_yaxis("美国男性", list(df.iloc[2])[1:])
        .add_yaxis("美国女性", list(df.iloc[3])[1:])
        .set_global_opts(title_opts=opts.TitleOpts(title="对比图1"))
    )
    line = (
        Line()
        .add_xaxis(list(df.set_index('指标').columns))
        .add_yaxis("中国男性", list(df.iloc[0])[1:])
        .add_yaxis("中国女性", list(df.iloc[1])[1:])
        .add_yaxis("美国男性", list(df.iloc[2])[1:])
        .add_yaxis("美国女性", list(df.iloc[3])[1:])
        .set_global_opts(
            title_opts=opts.TitleOpts(title="对比图2", pos_top="60%"),
            legend_opts=opts.LegendOpts(pos_top="60%"),
        )
    )

    grid = (
        Grid()
        .add(bar, grid_opts=opts.GridOpts(pos_bottom="60%"))
        .add(line, grid_opts=opts.GridOpts(pos_top="60%"))
    )
    return grid
grid_vertical().render_notebook()
Out[291]:

由中美心理健康患病率对比图可知,美国男女性的心理健康患病率远高于中国男女性。这或许与国家的福利制度、经济发展水平有着密切的联系。且美国女性的心理健康患病比例逐年与美国男性的比例拉大,而相反中国以及逐渐趋平甚至降低。综上,我们发现在大多数国家中,这种疾病在女性中比在男性中更为常见,这种情况因疾病类型而异:平均而言,抑郁症,焦虑症,进食障碍和躁郁症在女性中更为普遍。精神分裂症患病率的性别差异在各个国家参差不齐,但在男性中通常更为常见。酒精和药物滥用疾病在男性中更为常见。国家对国民的心理健康关注程度刻不容缓。

In [ ]: